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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-hackers by date

  From Date Subject
Next Message Zeugswetter Andreas SB 2001-03-05 16:47:33 AW: AW: WAL & RC1 status
Previous Message Bruce Momjian 2001-03-05 16:25:00 Re: AW: WAL & RC1 status