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:
2001-03-05 07:27:39 from Christof Petig <christof(dot)petig(at)wtal(dot)de>
2001-03-05 14:00:47 from Christof Petig <christof(at)petig-baender(dot)de>
2001-03-05 15:07:04 from Christof Petig <christof(at)petig-baender(dot)de>
2001-03-05 16:26:38 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2001-03-07 15:08:47 from Christof Petig <christof(at)petig-baender(dot)de>
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