Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Very slow left outer join
- From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
- To: "Tyrrill, Ed" <tyrrill_ed(at)emc(dot)com>
- Cc: "Klint Gore" <kg(at)kgb(dot)une(dot)edu(dot)au>, pgsql-performance(at)postgresql(dot)org
- Subject: Re: Very slow left outer join
- Date: Wed, 30 May 2007 12:59:11 -0400
"Tyrrill, Ed" <tyrrill_ed(at)emc(dot)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
- References:
- Very slow left outer join
- From: Tyrrill, Ed
- Re: Very slow left outer join
- From: Klint Gore
- Re: Very slow left outer join
- From: Tom Lane
- Re: Very slow left outer join
- From: Tyrrill, Ed
- Very slow left outer join
- Prev by Date: Re: Very slow left outer join
- Next by Date: Re: Bad RAID1 read performance
- Previous by thread: Re: Very slow left outer join
- Next by thread: Bad RAID1 read performance
- Indexes: