Re: Very slow left outer join - Mailing list pgsql-performance

From Tom Lane
Subject Re: Very slow left outer join
Date
Msg-id 5206.1180544351@sss.pgh.pa.us
Whole thread Raw
In response to Re: Very slow left outer join  ("Tyrrill, Ed" <tyrrill_ed@emc.com>)
List pgsql-performance
"Tyrrill, Ed" <tyrrill_ed@emc.com> writes:
> I did a vacuum analyze after inserting all the data.  Is there possibly
> a bug in analyze in 8.1.5-6?  I know it says rows=3D436915, but the last
> time the backup_location table has had that little data in it was a
> couple months ago, and analyze has been run many times since then.
> Currently it has over 160 million rows.

Possibly you need a larger statistics target for that table.

            regards, tom lane

pgsql-performance by date:

Previous
From: "Tyrrill, Ed"
Date:
Subject: Re: Very slow left outer join
Next
From: Dimitri
Date:
Subject: Re: Bad RAID1 read performance