Horton

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

Tom Lane <tgl@sss.pgh.pa.us>

View thread
From: Tom Lane <tgl@sss.pgh.pa.us>
To: christof@petig-baender.de
Cc: PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Date: 2001-03-05T16:26:38Z
Lists: pgsql-hackers 
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