Re: Analyze makes queries slow...

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Stef <svb(at)ucs(dot)co(dot)za>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Analyze makes queries slow...
Date: 2003-08-11 18:50:21
Message-ID: 5398.1060627821@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Stef <svb(at)ucs(dot)co(dot)za> writes:
> => And what PG version is this, exactly?

> PostgreSQL 7.3.1

Ah, I think I see it: you are getting burnt by a mergejoin estimation
bug that was fixed in 7.3.2. Please update (you might as well go to
7.3.4 while you're at it) and see if the results improve.

regards, tom lane

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Robert Treat 2003-08-11 18:53:12 Re: Windows on SuSE? 7.4
Previous Message Tom Lane 2003-08-11 18:25:03 Re: Analyze makes queries slow...