Re: Slow Query- Bad Row Estimate - Mailing list pgsql-performance

From Tom Lane
Subject Re: Slow Query- Bad Row Estimate
Date
Msg-id 10074.1288389805@sss.pgh.pa.us
Whole thread Raw
In response to Re: Slow Query- Bad Row Estimate  ("Ozer, Pam" <pozer@automotive.com>)
Responses Re: Slow Query- Bad Row Estimate  ("Ozer, Pam" <pozer@automotive.com>)
List pgsql-performance
"Ozer, Pam" <pozer@automotive.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

pgsql-performance by date:

Previous
From: "Ozer, Pam"
Date:
Subject: Re: Slow Query- Bad Row Estimate
Next
From: "Ozer, Pam"
Date:
Subject: Re: Slow Query- Bad Row Estimate