Postgres Pro
Downloads
Home   >   mailing lists

Re: Analyze makes queries slow... - Mailing list pgsql-performance

From Tom Lane
Subject Re: Analyze makes queries slow...
Date
Msg-id 5398.1060627821@sss.pgh.pa.us
Whole thread Raw
In response to Re: Analyze makes queries slow...  (Stef <svb@ucs.co.za>)
List pgsql-performance
Tree view 
Stef <svb@ucs.co.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

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Analyze makes queries slow...
Next
From: Josh Berkus
Date:
Subject: Odd problem with performance in duplicate database