Re: dates and partitioning

От: Jochen Erwied
Тема: Re: dates and partitioning
Дата: ,
(см: обсуждение, исходный текст)
Ответ на: dates and partitioning  (Kevin Kempter)
Список: pgsql-performance

Tuesday, July 20, 2010, 5:36:07 PM you wrote:

> 2) the above query creates a plan that does a sequential scan & filter on
> every partition. Why won't it only hit the correct partitions? Is it due to
> the way the date was specified? or maybe the "at time zone" syntax?

Quick guess: How is your 'constraint_exclusion'-setting?
Which version of postgres?

Jochen Erwied     |   home:      +49-208-38800-18, FAX: -19
Sauerbruchstr. 17 |   work:   +49-2151-7294-24, FAX: -50
D-45470 Muelheim  | mobile:        +49-173-5404164

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

От: Pavel Stehule
Сообщение: Re: potential performance gain by query planner optimization
От: Scott Carey
Сообщение: Re: IDE x SAS RAID 0 on HP DL 380 G5 P400i controller performance problem