Postgres Pro
Downloads
Home   >   mailing lists

Re: Query Plan Performance on Partitioned Table - Mailing list pgsql-performance

From Maxim Boguk
Subject Re: Query Plan Performance on Partitioned Table
Date
Msg-id CAK-MWwSM1rs8K4FB5-04o1NXpJYz93+LS46WLsvz0UuWQOXTuA@mail.gmail.com
Whole thread Raw
In response to Re: Query Plan Performance on Partitioned Table  (Rural Hunter <ruralhunter@gmail.com>)
Responses Re: Query Plan Performance on Partitioned Table
List pgsql-performance
Tree view


On Tue, Aug 11, 2015 at 11:44 PM, Rural Hunter <ruralhunter@gmail.com> wrote:
# \dt+
​​
article_729
                      List of relations
 Schema |    Name     | Type  | Owner  |  Size  | Description
--------+-------------+-------+--------+--------+-------------
 public | article_729 | table | omuser1 | 655 MB |
(1 row)
The problem exists on not only this specific child table, but with all of them.

​Oops sorry, оf course I mean "\d+​
 ​ article_729
​" (to see criteria used for partitioning).​



--
Maxim Boguk
Senior Postgresql DBA
http://www.postgresql-consulting.ru/

pgsql-performance by date:

Previous
From: Rural Hunter
Date:
Subject: Re: Query Plan Performance on Partitioned Table
Next
From: Rural Hunter
Date:
Subject: Re: Query Plan Performance on Partitioned Table