Re: Slow Query- Bad Row Estimate

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Ozer, Pam" <pozer(at)automotive(dot)com>
Cc: "Josh Berkus" <josh(at)agliodbs(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Slow Query- Bad Row Estimate
Date: 2010-10-29 22:03:25
Message-ID: 10074.1288389805@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

"Ozer, Pam" <pozer(at)automotive(dot)com> writes:
> Yes. The default statistics target was at 1000. So that would be what the column was using correct?

But you evidently didn't have stats. Perhaps you have autovacuum turned
off? What PG version is this anyway?

regards, tom lane

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Ozer, Pam 2010-10-29 22:10:16 Re: Slow Query- Bad Row Estimate
Previous Message Ozer, Pam 2010-10-29 21:55:59 Re: Slow Query- Bad Row Estimate