Re: Slow Query- Bad Row Estimate

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

 



"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