Its 8.4. On the column stats_target=-1 before I changed it. AutoVacuum
is set to on. I actually did a full analyze of the database and then
ran it again. So what am I missing?
From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
Sent: Friday, October 29, 2010 3:03 PM
To: Ozer, Pam
Cc: Josh Berkus; pgsql-performance(at)postgresql(dot)org
Subject: Re: [PERFORM] Slow Query- Bad Row Estimate
"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
pgsql-performance by date
|Next:||From: Robert Haas||Date: 2010-10-30 00:24:54|
|Subject: Re: [PERFORM] typoed column name, but postgres didn't grump|
|Previous:||From: Tom Lane||Date: 2010-10-29 22:03:25|
|Subject: Re: Slow Query- Bad Row Estimate |