Re: Big difference in time returned by EXPLAIN ANALYZE SELECT ... AND SELECT ...

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Piotr Gasidło <quaker(at)barbara(dot)eu(dot)org>
Cc: Vitalii Tymchyshyn <tivv00(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Big difference in time returned by EXPLAIN ANALYZE SELECT ... AND SELECT ...
Date: 2010-07-27 04:19:03
Message-ID: 29602.1280204343@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

=?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

Browse pgsql-performance by date

  From Date Subject
Next Message Mark Kirkwood 2010-07-27 05:04:47 Linux Filesystems again - Ubuntu this time
Previous Message Lew 2010-07-26 23:03:58 Re: Big difference in time returned by EXPLAIN ANALYZE SELECT ... AND SELECT ...