Inheritance and sharding with Postgres
I’ve used sharding with inheritance in the past but on a warehousing backend where we did not need to worry about locks. Using LIKE to define child tables creates a maintenance burden but there are ways to work around it in your application code which can be made ‘version’ aware. In effect you would never update old shards and only add those columns in the newer shards – the application code being
Sharding & IDs at Instagram
Welcome to the Instagram Engineering Blog, where we share insights on building and scaling our service. With more than 25 photos & 90 likes every second, we store a lot of data here at Instagram. To make sure all of our important data fits into memory and is available quickly for our users, we’ve begun to shard our data—in other words, place the data in many smaller buckets, each holding a part of
Rails ã§ã€Controller ã«å®šç¾©ã•ã‚Œã¦ã„ã‚‹ action を一度ã«å–å¾—ã™ã‚‹æ–¹æ³•ã¯ã‚ã‚Šã¾ã™ã‹ï¼Ÿ - QA@IT
å¹³ç´ ã‚ˆã‚ŠQAï¼ ITã‚’ã”利用ã„ãŸã ãã€èª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ QAï¼ ITã¯ã€Œè³ªå•ã‚„回ç”を『共有ã€ã—『編集ã€ã—ã¦ã„ãã“ã¨ã§ãƒ™ã‚¹ãƒˆãªQAã‚’è“„ç©ã§ãã‚‹ã€ITエンジニアã®ãŸã‚ã®å•é¡Œè§£æ±ºã‚³ãƒŸãƒ¥ãƒ‹ãƒ†ã‚£ãƒ¼ã€ã¨ã—ã¦ç´„7å¹´é–“é‹å–¶ã‚’ã—ã¦ãã¾ã—ãŸã€‚ã“ã‚Œã¾ã§ã‚µãƒ¼ãƒ“スを続ã‘ã‚‹ã“ã¨ãŒã§ããŸã®ã¯ã€QAï¼ ITã®ã‚³ãƒ³ã‚»ãƒ—トã«å…±æ„Ÿã‚’ã„ãŸã ãã€é©åˆ‡ãªè³ªå•ã‚„回ç”ã‚’ãŠå¯„ã›ã„ãŸã ã„ãŸçš†ã•ã¾ã®ã”支æ´ãŒã‚ã£ãŸã‹ã‚‰ã“ãã¨è€ƒãˆã¦ãŠã‚Šã¾ã™ã€‚é‡ãã¦å¾¡ç¤¼ç”³ã—上ã’ã¾ã™ã€‚ ã—ã‹ã—ãªãŒã‚‰ã€ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®æƒ…å ±å…¥æ‰‹æ–¹æ³•ã®å¤šæ§˜åŒ–ã‚„QAã‚µãƒ¼ãƒ“ã‚¹å¸‚å ´ã®çŠ¶æ³ã€ï¼ ITã®ä»Šå¾Œã®ãƒ¡ãƒ‡ã‚£ã‚¢é‹å–¶æ–¹é‡ãªã©ã‚’検討ã—ãŸçµæžœã€2020å¹´2月28日（金）15:00ã‚’ã‚‚ã¡ã¾ã—ã¦QAï¼ ITã®ã‚µãƒ¼ãƒ“スを終了ã™ã‚‹ã“ã¨ã«ã—ã¾ã—ãŸã€‚ ã“ã‚Œã¾ã§ã”利用をã„ãŸã ãã¾ã—ãŸçš†ã•ã¾ã«ã¯æ®‹å¿µãªãŠçŸ¥ã‚‰ã›ã¨ãªã‚Šã€èª ã«å¿ƒè‹¦ã—ãæ€ã£ã¦ãŠã‚Šã¾ã™ã€‚何ã¨ãžã€ã”ç†è§£ã‚’ã„ãŸã ã‘ã¾ã™ã¨å¹¸ã„ã§ã™ã€‚ QAï¼ ITã®7å¹´é–“ã§çš†ã•ã¾ã®çŸ¥è˜
Slow Query Questions - PostgreSQL wiki
Guide to Asking Slow Query Questions In any given week, some 50% of the questions on #postgresql IRC and 75% on pgsql-performance are requests for help with a slow query. However, it is rare for the requester to include complete information about their slow query, frustrating both them and those who try to help. Please post performance related questions to the pgsql-performance mailing list or to
Reading PgAdmin Graphical Explain Plans - Postgres OnLine Journal
One of our favorite features of PgAdmin is the graphical explain plan feature. While a graphical explain plan is not a complete substitute for EXPLAIN or EXPLAIN ANALYZE text plans, it does provide a quick and easy to read view that can be used for further analysis. In this article, we'll walk thru using the explain plan to troubleshoot query performance. To use the graphical explain plan feature
SQLアタマアカデミー 記事一覧 | gihyo.jp
最終回　OLAP関数ã§å¼·åŠ›ãªçµ±è¨ˆå‡¦ç†ã‚’実ç¾ï¼â€•æ‰‹ç¶šãåž‹ã‹ã‚‰ç†è§£ã™ã‚‹SQL　（5）集åˆæŒ‡å‘ã¨æ‰‹ç¶šãåž‹ ミック 2010-05-28 最終回　OLAP関数ã§å¼·åŠ›ãªçµ±è¨ˆå‡¦ç†ã‚’実ç¾ï¼â€•æ‰‹ç¶šãåž‹ã‹ã‚‰ç†è§£ã™ã‚‹SQL　（4）OLAP関数ã¨é›†ç´„関数を組ã¿åˆã‚ã›ã‚‹ ミック 2010-05-27
DBアタマアカデミー 記事一覧 | gihyo.jp
最終回　治療ã¨ã—ã¦ã®ãƒ‘フォーマンスãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°â€•ã‚·ã‚¹ãƒ†ãƒ ã®ç—…æ°—ã¯ã©ã†æ²»ã™ï¼Ÿï¼ˆ3） ミック 2011-04-01
PostgreSQL tuning technique
PostgreSQLãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ãƒ†ã‚¯ãƒ‹ãƒƒã‚¯é›† SELECT ... WHERE foo = 100 ORDER BY barã‚’SELECT ... WHERE foo = 100 ORDER BY i, jã«æ›¸ãæ›ãˆã‚‹(2004/08/18掲載) SELECT * FROM t1 WHERE i = 100 ORDER BY j; ã®ã‚ˆã†ãªãƒ‘ターンã®æ¤œç´¢ã§ã¯ï¼Œiã«ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’貼るã“ã¨ã§ã‚る程度ã®é«˜ 速化ãŒã§ãã¾ã™ãŒï¼Œãã®å¾Œã§ã‚½ãƒ¼ãƒˆãŒç™ºç”Ÿã—，速度低下ã®è¦å› ã«ãªã‚Šã¾ã™ï¼Ž SELECT * FROM t1 WHERE i = 100 ORDER BY j LIMIT 5; ã®ã‚ˆã†ã«ï¼Œå‡ºåŠ›çµæžœä»¶æ•°ã‚’制é™ã—ã‹ã¤jã«ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’貼るã¨ï¼Œä»Šåº¦ã¯jã®ã‚¤ ンデックスを使ã†ã‚ˆã†ã«ãªã‚Šã¾ã™ï¼Ž ã—ã‹ã—，よã考ãˆã¦ã¿ã‚‹ã¨ï¼Œiã§æ¤œç´¢ã—，jã§ã‚½ãƒ¼ãƒˆã™ã‚‹ã®ã¯iã¨jã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ スã®ä¸¡æ–¹ã‚’使ãˆã°ä¸€åº¦ã«ã§ãã‚‹ã¯ãšã§ã™
Explaining Explain ～ PostgreSQLã®å®Ÿè¡Œè¨ˆç”»ã‚’èªã‚€ ～ (PDF版) — Let's Postgres
EXPLAIN ã‚„ EXPLAIN ANALYZE ã®ä½¿ã„æ–¹ã¨ã€ãれらを利用ã—ã¦ã‚¹ãƒãƒ¼ã‚¯ã‚¨ãƒªã®å®Ÿè¡Œè¨ˆç”»ã‚’改善ã™ã‚‹æ–¹æ³•ã‚’紹介ã—ã¾ã™ã€‚ Explaining Explain ～ PostgreSQLã®å®Ÿè¡Œè¨ˆç”»ã‚’èªã‚€ ～ (PDF版) OSCON 2005 ã§è¬›æ¼”ã•ã‚Œã€2005å¹´ã®JPUGå¤åˆå®¿ã§åˆ†æ‹…ã—ã¦ç¿»è¨³ã—ãŸç™ºè¡¨è³‡æ–™ã§ã™ã€‚PostgreSQL 8.3 ã«å¯¾å¿œã§ãるよã†å†…容を更新ã—ã¦ã„ã¾ã™ã€‚ Explaining Explain ～ PostgreSQLã®å®Ÿè¡Œè¨ˆç”»ã‚’èªã‚€ ～ (PPT版) OSCON 2005 ã§è¬›æ¼”ã•ã‚Œã€2005å¹´ã®JPUGå¤åˆå®¿ã§åˆ†æ‹…ã—ã¦ç¿»è¨³ã—ãŸç™ºè¡¨è³‡æ–™ã§ã™ã€‚PostgreSQL 8.3 ã«å¯¾å¿œã§ãるよã†å†…容を更新ã—ã¦ã„ã¾ã™ã€‚
サービス終了ã®ãŠçŸ¥ã‚‰ã›
サービス終了ã®ãŠçŸ¥ã‚‰ã› ã„ã¤ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“スをã”利用ã„ãŸã ãèª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ ãŠå®¢æ§˜ãŒã‚¢ã‚¯ã‚»ã‚¹ã•ã‚ŒãŸã‚µãƒ¼ãƒ“スã¯æœ¬æ—¥ã¾ã§ã«ã‚µãƒ¼ãƒ“スを終了ã„ãŸã—ã¾ã—ãŸã€‚ 今後ã¨ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“スをã”愛顧ãã ã•ã„ã¾ã™ã‚ˆã†ã€ã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚
A5:SQL Mk-2 - フリーã®æ±Žç”¨SQL開発ツール/ER図ツール
A5:SQL Mk-2ã¯è¤‡é›‘化ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹é–‹ç™ºã‚’支æ´ã™ã‚‹ãŸã‚ã«é–‹ç™ºã•ã‚ŒãŸãƒ•ãƒªãƒ¼ã®SQL開発ツールã§ã™ã€‚ 高機能ã‹ã¤è»½é‡ã§ã€ä½¿ã„æ–¹ãŒåˆ†ã‹ã‚Šã‚„ã™ã„ã“ã¨ã‚’目標ã«é–‹ç™ºã•ã‚Œã¦ã„ã¾ã™ã€‚ SQLを実行ã—ãŸã‚Šã€ãƒ†ãƒ¼ãƒ–ルを編集ã™ã‚‹ã»ã‹ã«ã€SQLã®å®Ÿè¡Œè¨ˆç”»ã‚’å–å¾—ã—ãŸã‚Šã€ER図を作æˆã—ãŸã‚Šã™ã‚‹ã“ã¨ãŒå‡ºæ¥ã¾ã™ã€‚ 特徴・機能 OCI接続・直接接続・ADOã¾ãŸã¯ODBCを介ã—ãŸDBã¸ã®æŽ¥ç¶š Oracle Databaseã¯OCI経由ã®æŽ¥ç¶šãƒ»ç›´æŽ¥æŽ¥ç¶šãŒå‡ºæ¥ã¾ã™ã€‚ PostgreSQLã¨MySQLã¯ç›´æŽ¥æŽ¥ç¶šãŒå‡ºæ¥ã¾ã™ã€‚ Microsoft SQL Serverã¯ã€OLE DBプãƒãƒã‚¤ãƒ€ã‚’直接呼ã³å‡ºã—ãŸæŽ¥ç¶šãŒã§ãã¾ã™ã€‚ IBM DB2ã¯ã€ODBCドライãƒã‚’直接呼ã³å‡ºã—ãŸæŽ¥ç¶šãŒã§ãã¾ã™ã€‚ ãã®ä»–ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯ã€ADOã¾ãŸã¯ODBCを利用ã—ã¦æŽ¥ç¶šã—ã¾ã™ã€‚ Oracle, PostgreSQL, MySQLã¯ã€A5:SQL
PostgreSQLã®å°Žå…¥ã¨åˆæœŸè¨å®š — Let's Postgres
NTT オープンソースソフトウェアセンタ æ¿åž£ 貴裕 ã“ã®è¨˜äº‹ã¯ã€gihyo.jp & Let's Postgres 連動ä¼ç”»ã€Œä»Šã“ãï¼PostgreSQLã€ã®ç¬¬4回記事ã§ã™ã€‚「PostgreSQLã®ä»Šã‚’知るã€ã‚·ãƒªãƒ¼ã‚ºã«ç¶šãã€ä»Šå›žã‹ã‚‰ 4回ã«åˆ†ã‘㦠PostgreSQL ã®ä½¿ã„方を解説ã—ã¦ã„ãã¾ã™ã€‚第4回目ã¯ã€PostgreSQL ã®å°Žå…¥ã€ç®¡ç†ãƒ„ール類ã€é‹ç”¨ã‚’始ã‚ã‚‹å‰ã«ç¢ºèªã—ã¦ãŠãã¹ããƒã‚¤ãƒ³ãƒˆã«ã¤ã„ã¦è§£èª¬ã—ã¾ã™ã€‚ インストールã€åŸºæœ¬ãƒ„ールã€è¿½åŠ ã® GUI ツールã«ã¤ã„ã¦è§£èª¬ã—ã¾ã™ã€‚ インストール PostgreSQL ã¯ã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ã‚„実行ãƒã‚¤ãƒŠãƒªã®å½¢å¼ã§é…布ã•ã‚Œã¦ã„ã¾ã™ã€‚32bit版㨠64bit版ãŒã‚ã‚Šã¾ã™ãŒã€OS ã«ä½µã›ã¦é¸ã¶ã®ãŒé©å½“ã ã¨æ€ã„ã¾ã™ã€‚(Windows ã§ã¯ 32bit版ã®ã¿) インストールã®æ‰‹é †ã¯ã€Œç›®çš„別ガイド：インストール編ã€ã«ä¸€è¦§ãŒã‚ã‚Šã¾ã™ã€‚CentOS, Ubunt
Big Bad PostgreSQL @ Percona
1. Big Bad PostgreSQL: A Case Study Moving a “large,†“complicated,†and mission-critical datawarehouse from Oracle to PostgreSQL for cost control. 1 2. About the Speaker • Principal @ OmniTI S32699X_Scalable_Internet.qxd 6/23/06 3:31 PM Page 1 Scalable Internet Architectures • Open Source Theo Schlossnagle Scalable Internet Architectures With an estimated one billion users worldwide, the Internet
[ThinkIT] 第3回：トランザクションã®æ¯”較 (1/4) -at- 徹底比較!! PostgreSQL vs MySQL
トランザクション機能をサãƒãƒ¼ãƒˆã—ã¦ã„ã‚‹ã®ã¯ã€PostgreSQLã¨MySQL＋InnoDBエンジンã§ã‚ã‚Šã€MySQL＋MyISAMエンジンã¯ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³æ©Ÿèƒ½ã‚’サãƒãƒ¼ãƒˆã—ã¦ã„ã¾ã›ã‚“。ã“ã“ã§ã®ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³æ©Ÿèƒ½ã¨ã¯ã€è¤‡æ•°ã®ãƒ†ãƒ¼ãƒ–ルやレコードã«å½±éŸ¿ã‚’ãŠã‚ˆã¼ã™å‡¦ç†ã‚’1ã¤ã®å˜ä½ã¨ã¿ãªã—ã€ã“ã®å˜ä½ã§ã®å‡¦ç†çµæžœã‚’ä¿è¨¼ã™ã‚‹æ©Ÿèƒ½ã‚’指ã—ã¾ã™ã€‚ 具体的ã«ã¯ã€BEGINæ–‡ã«ã¦ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã‚’開始ã—ã¦ã„ãã¤ã‹ã®å‡¦ç†ã‚’è¡Œã£ãŸå¾Œã€å‡¦ç†ã‚’確定ã™ã‚‹å ´åˆã¯COMMITæ–‡ã€å‡¦ç†ã‚’å–り消ã™å ´åˆã¯ROLLBACK文を使用ã—ã€ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã‚’終了ã•ã›ã‚‹ã¾ã§ã®å‡¦ç†ã§ã™ã€‚ トランザクション分離レベルã¨ã¯ã€è¤‡æ•°ã®ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ãŒåŒæ™‚ã«å®Ÿè¡Œã•ã‚ŒãŸå ´åˆã«ã€ä»–ã®ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã‹ã‚‰ã®å½±éŸ¿ãŒã©ã®ãらã„分離ã™ã‚‹ã‹ã®ãƒ¬ãƒ™ãƒ«ã‚’æ„味ã—ã¾ã™ã€‚ ANSI/ISO SQLè¦æ ¼ï¼ˆSQL92）ã§ã¯4ã¤ã®åˆ†é›¢ãƒ¬ãƒ™ãƒ«ï¼ˆä¸‹è¨˜ã‚³ãƒ©ãƒ å‚照）ãŒå®šç¾©ã•ã‚Œã¦ã„ã¾ã™ã€‚P
削除フラグã®ã¯ãªã—
6. id name pass is_deleted 1 ryu xxx FALSE 2 ken xxx FALSE 3 honda xxx TRUE 8. id name pass is_deleted 1 ryu xxx FALSE 2 ken xxx FALSE 3 honda xxx TRUE 3 honda xxx FALSE
1
ランã‚ング
ランã‚ング
ランã‚ング
リリースã€éšœå®³æƒ…å ±ãªã©ã®ã‚µãƒ¼ãƒ“スã®ãŠçŸ¥ã‚‰ã›
最新ã®äººæ°—エントリーã®é…ä¿¡
j次ã®ãƒ–ックマーク
kå‰ã®ãƒ–ックマーク
lã‚ã¨ã§èªã‚€
eコメント一覧を開ã
oページを開ã
PostgreSQL 9.0.1文書
{{#tags}}- {{label}}
{{/tags}}