PostgreSQLã§å®‰å…¨ã«ãƒ†ãƒ¼ãƒ–ル定義を変更ã™ã‚‹ - LCL Engineers' BlogWebエンジニアã®æ£®è„‡ã§ã™ã€‚ PostgreSQLã§ã€ã‚µãƒ¼ãƒ“ス稼åƒä¸ã«å®‰æ˜“ã«ALTER TABLEç‰ã‚’実行ã™ã‚‹ã¨ã€ãƒ€ã‚¦ãƒ³ã‚¿ã‚¤ãƒ ã«ç¹‹ãŒã‚‹ã“ã¨ãŒã‚ã‚Šã¾ã™ã€‚安全ã«ãƒ†ãƒ¼ãƒ–ル定義を変更ã™ã‚‹ãŸã‚ã«ã€å¼Šç¤¾ã§æ°—ã‚’ã¤ã‘ã¦ã„る点を紹介ã—ã¾ã™ã€‚ ãªãŠã€æœ¬è¨˜äº‹ã®å†…容㯠PostgreSQL 9.5.4 環境ã§ç¢ºèªã—ã¦ã„ã¾ã™ã€‚ PostgreSQLã®ãƒãƒƒã‚¯ã«ã¤ã„㦠å‚ç…§ã®ã¿ã®ãƒ†ãƒ¼ãƒ–ルã«å¯¾ã—ã¦ã€ALTER TABLEを実行ã—ãŸå ´åˆã§ã‚‚ダウンタイムã«ç¹‹ãŒã‚‹ã“ã¨ãŒã‚ã‚Šã¾ã™ã€‚åŽŸå› ã«ã¤ã„ã¦ç†è§£ã™ã‚‹ãŸã‚ã«ã€PostgreSQLã®ãƒãƒƒã‚¯ã«ã¤ã„ã¦ç°¡å˜ã«ç´¹ä»‹ã—ã¾ã™ã€‚ PostgreSQLã§ã¯ã€SELECTã§ã‚‚「ACCESS SHAREã€ã¨ã„ã†ãƒãƒƒã‚¯ã‚’ç²å¾—ã—ã¾ã™ã€‚最も弱ã„ãƒãƒƒã‚¯ã§ã™ãŒã€ALTER TABLEç‰ã§ç²å¾—ã•ã‚Œã‚‹ã€ŒACCESS EXCLUSIVEã€ã¨ã„ã†ãƒãƒƒã‚¯ã¨ç«¶åˆã—ã¾ã™ã€‚ ã“ã‚Œã¯ã€ä»–ã®ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã§SELECTã—ã¦ã„るテ
PostgreSQLã®ãƒˆãƒ©ãƒ–ãƒ«ã‚·ãƒ¥ãƒ¼ãƒ†ã‚£ãƒ³ã‚°ï¼ ç¬¬5回ä¸å›½åœ°æ–¹DB勉強会
PostgreSQLã®è¨å®š ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚° — ãã“ã¯ã‹ã¨ãªã書ãよん。 ドã‚ュメント
PostgreSQL ã®ç¯„囲型ã«ã¤ã„㦠- Qiita
[翻訳] ãŸã£ãŸä¸€ã¤ã®è¨å®šå¤‰æ›´ãŒå¦‚何ã«ã—ã¦ã‚¯ã‚¨ãƒªã®ãƒ‘フォーマンスを50å€ã‚‚改善ã—ãŸã‹ （How a single PostgreSQL config change improved slow query performance by 50x）
Progress on online upgrade - 2ndQuadrant | PostgreSQL
Migrating Postgres to RDS without downtime
Amazon RDS for PostgreSQL now supports Read Replicas, PostgreSQL 9.3.5, Data Migration enhancements, and Three New Extensions
PostgreSQL replication to Amazon RDS
{{#tags}}- {{label}}
{{/tags}}