postgres_fdwã§ç•°ãƒãƒ¼ã‚¸ãƒ§ãƒ³æŽ¥ç¶š/外部表ã®ã‚«ã‚¹ã‚±ãƒ¼ãƒ‰ - 日々ã®è¨˜éŒ² 別館PostgreSQL 9.6/9.5ã®postgres_fdwã®å·®ç•°ã‚’調ã¹ã¦ã„ã¦ã€ãµã¨æ°—ã«ãªã£ãŸã“ã¨ã‚’調ã¹ã¦ã¿ãŸã€‚ ç•°ãƒãƒ¼ã‚¸ãƒ§ãƒ³é–“ã§FDW PostgreSQL 9.6/9.5ã®postgres_fdwã®å·®ç•°ã‚’調ã¹ã¦ã„ã¦ã€ãµã¨æ°—ã«ãªã£ãŸã®ã ã‘ã©ã€ç•°ãªã‚‹ãƒãƒ¼ã‚¸ãƒ§ãƒ³é–“ã‚’postgres_fdwã§æŽ¥ç¶šã£ã¦ã§ããŸã£ã‘。 ã¨ã„ã†ã“ã¨ã§ã‚„ã£ã¦ã¿ãŸã€‚ ãƒãƒ¼ã‚«ãƒ«ã‚µãƒ¼ãƒãŒ9.6ã€ãƒªãƒ¢ãƒ¼ãƒˆã‚µãƒ¼ãƒãŒ9.5ã®å ´åˆã€‚ bench=# EXPLAIN ANALYZE VERBOSE SELECT AVG(a.data1), AVG(a.data2) FROM table_a a JOIN table_b b ON (a.id = b.id) WHERE a.data1 = 10000 ; QUERY PLAN ------------------------------------------------------
{{#tags}}- {{label}}
{{/tags}}