From: | Rural Hunter <ruralhunter(at)gmail(dot)com> |
---|---|
To: | Pietro Pugni <pietro(dot)pugni(at)gmail(dot)com> |
Cc: | Maxim Boguk <maxim(dot)boguk(at)gmail(dot)com>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org> |
Subject: | Re: Query Plan Performance on Partitioned Table |
Date: | 2015-08-12 01:49:42 |
Message-ID: | CAOe1oo8nCEZnijp7_Ba9MZWUHg4jQnYpuPUwu_hU1M1HBQcJEA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
article_729 has about 0.8 million rows. The rows of the children tables are
variance from several thousands to dozens of millions. How can it help to
create index on the partition key?
2015-08-12 1:03 GMT+08:00 Pietro Pugni <pietro(dot)pugni(at)gmail(dot)com>:
> Hi Rural Hunter,
> Try to create an index on cid attribute.
> How many rows has article_729?
>
> Pietro Pugni
> Il 11/ago/2015 16:51, "Rural Hunter" <ruralhunter(at)gmail(dot)com> ha scritto:
>
>> yes i'm very sure. from what i observed, it has something to do with the
>> concurrent query planing. if i disconnect other connections, the plan is
>> very quick.
>>
>> 2015-08-11 22:42 GMT+08:00 Maxim Boguk <maxim(dot)boguk(at)gmail(dot)com>:
>>
>>>
>>>
>>> Check constraints:
>>>> "article_729_cid_check" CHECK (cid = 729)
>>>>
>>>
>>>
>>> Used partition schema looks very simple and straightforward, and should
>>> have no issues with 80 partitions.
>>> Are you sure that you have only 80 partitions but not (lets say) 800?
>>> Are every other partition of the article table use the same general idea
>>> of partition check (cid=something)?
>>>
>>>
>>> Maxim Boguk
>>> Senior Postgresql DBA
>>> http://www.postgresql-consulting.ru/
>>> <http://www.postgresql-consulting.com/>
>>>
>>> Phone RU: +7 910 405 4718
>>> Phone AU: +61 45 218 5678
>>>
>>> LinkedIn: http://www.linkedin.com/pub/maksym-boguk/80/b99/b1b
>>> Skype: maxim.boguk
>>> Jabber: maxim(dot)boguk(at)gmail(dot)com
>>> МойКруг: http://mboguk.moikrug.ru/
>>>
>>> "People problems are solved with people.
>>> If people cannot solve the problem, try technology.
>>> People will then wish they'd listened at the first stage."
>>>
>>>
>>
From | Date | Subject | |
---|---|---|---|
Next Message | robbyc | 2015-08-12 02:34:20 | Slow Query |
Previous Message | Pietro Pugni | 2015-08-11 17:03:25 | Re: Query Plan Performance on Partitioned Table |