Postgres Pro
Downloads
Home   >   mailing lists

Re: bad join performance - Mailing list pgsql-performance

From Tom Lane
Subject Re: bad join performance
Date
Msg-id 28775.1061232021@sss.pgh.pa.us
Whole thread Raw
In response to bad join performance  (pginfo <pginfo@t1.unisoftbg.com>)
List pgsql-performance
Tree view 
pginfo <pginfo@t1.unisoftbg.com> writes:
> I am using pg 7.3.3 on RH 7.3,

Are you certain the server is 7.3.3?  This looks like a mergejoin
estimation bug that was present in 7.3 and 7.3.1, but should be fixed
in 7.3.2 and later.

If it is 7.3.3, I'd like to see the pg_stats rows for
a_acc.ids_vid_doc and a_vid_doc.ids.

            regards, tom lane

pgsql-performance by date:

Previous
From: Hannu Krosing
Date:
Subject: Re: Insert performance
Next
From: Stephan Szabo
Date:
Subject: Re: bad join performance