Horton

Re: Query Planning time increased 3 times on 7.1 compared to 7.0.3

Christof Petig <christof@petig-baender.de>

View thread
From: Christof Petig <christof@petig-baender.de>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Date: 2001-03-07T15:08:47Z
Lists: pgsql-hackers 
Tom Lane wrote:

> Christof Petig <christof.petig@wtal.de> writes:
> > We noticed that after upgrading to 7.1beta[245] the execution time for
> > some often used queries went up by a factor of 2 or more.
>
> I get the desired plan after doing VACUUM ANALYZE ...
>
>                         regards, tom lane

I apologize. I must have been smoking something when I did the vacuum
analyze. And my nightly script did not work. 7.1 is much faster.

Christof