Postgres Pro
Downloads
Home   >   mailing lists

Re: Big difference in time returned by EXPLAIN ANALYZE SELECT ... AND SELECT ... - Mailing list pgsql-performance

From Tom Lane
Subject Re: Big difference in time returned by EXPLAIN ANALYZE SELECT ... AND SELECT ...
Date
Msg-id 29602.1280204343@sss.pgh.pa.us
Whole thread Raw
In response to Re: Big difference in time returned by EXPLAIN ANALYZE SELECT ... AND SELECT ...  (Piotr Gasidło <quaker@barbara.eu.org>)
List pgsql-performance
Tree view 
=?UTF-8?Q?Piotr_Gasid=C5=82o?= <quaker@barbara.eu.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

pgsql-performance by date:

Previous
From: Greg Smith
Date:
Subject: Re: Testing Sandforce SSD
Next
From: Mark Kirkwood
Date:
Subject: Linux Filesystems again - Ubuntu this time