Re: Question about partitioned query behavior

От: Ranga Gopalan
Тема: Re: Question about partitioned query behavior
Дата: ,
Msg-id: SNT129-W389B6BFE3A469C79A3F90B91B20@phx.gbl
(см: обсуждение, исходный текст)
Ответ на: Re: Question about partitioned query behavior  (Stephen Frost)
Список: pgsql-performance

Скрыть дерево обсуждения

Question about partitioned query behavior  (Ranga Gopalan, )
 Re: Question about partitioned query behavior  ("Benjamin Krajmalnik", )
 Re: Question about partitioned query behavior  (Ranga Gopalan, )
  Re: Question about partitioned query behavior  (Robert Haas, )
  Re: Question about partitioned query behavior  (Stephen Frost, )
   Re: Question about partitioned query behavior  (Ranga Gopalan, )

Hi Stephen,

Constraint exclusion was initially partition and I set it to "on" as suggested and tried that - the query planner in both cases was correctly identifying the specific partitions being queried - the problem seems to be a generic issue related to the way queries on partition tables are handled and how the order by / limit is applied in this scenario.

Thanks,

Ranga

> Date: Tue, 6 Jul 2010 16:26:23 -0400
> From:
> To:
> CC:
> Subject: Re: [PERFORM] Question about partitioned query behavior
>
> Ranga,
>
> * Ranga Gopalan () wrote:
> > It seems that this is an issue faced by others as well - Please see this link: http://stackoverflow.com/questions/2236776/efficient-querying-of-multi-partition-postgres-table
> >
> > Is this a known bug? Is this something that someone is working on or is there a known work around?
>
> Actually, if you look at that, the problem the original poster had was
> that they didn't have constraint_exclusion turned on. Then they were
> complaining about having the (empty) master table and the needed
> partition included (which, really, shouldn't be that big a deal).
>
> Did you look at what the other reply suggested? Do you have
> constraint_exclusion = 'on' in your postgresql.conf?
>
> Thanks,
>
> Stephen


The New Busy is not the too busy. Combine all your e-mail accounts with Hotmail. Get busy.

В списке pgsql-performance по дате сообщения:

От: Richard Yen
Дата:
Сообщение: WAL partition overloaded--by autovacuum?
От: Scott Marlowe
Дата:
Сообщение: Re: WAL partition overloaded--by autovacuum?