Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group