=?UTF-8?Q?Piotr_Gasid=C5=82o?= <quaker(at)barbara(dot)eu(dot)org> writes:
> Ok. Is there any way to tune postgresql, to shorten planning time for
> such queries?
You've got a ridiculously large number of partitions. Use fewer.
regards, tom lane
In response to
pgsql-performance by date
|Next:||From: Mark Kirkwood||Date: 2010-07-27 05:04:47|
|Subject: Linux Filesystems again - Ubuntu this time|
|Previous:||From: Lew||Date: 2010-07-26 23:03:58|
|Subject: Re: Big difference in time returned by EXPLAIN ANALYZE
SELECT ... AND SELECT ...|