Re: Slow Query- Bad Row Estimate

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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?

-----Original Message-----
From: Tom Lane [mailto:tgl@xxxxxxxxxxxxx] 
Sent: Friday, October 29, 2010 3:03 PM
To: Ozer, Pam
Cc: Josh Berkus; pgsql-performance@xxxxxxxxxxxxxx
Subject: Re:  Slow Query- Bad Row Estimate 

"Ozer, Pam" <pozer@xxxxxxxxxxxxxx> 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

-- 
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance



[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux