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

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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: christof(at)petig-baender(dot)de
Cc: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Query Planning time increased 3 times on 7.1 compared to 7.0.3
Date: 2001-03-05 16:26:38
Message-ID: 19919.983809598@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
Christof Petig <christof(dot)petig(at)wtal(dot)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

In response to

Responses

pgsql-hackers by date

Next:From: Zeugswetter Andreas SBDate: 2001-03-05 16:47:33
Subject: AW: AW: WAL & RC1 status
Previous:From: Bruce MomjianDate: 2001-03-05 16:25:00
Subject: Re: AW: WAL & RC1 status

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