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:[email protected]] Sent: Friday, October 29, 2010 3:03 PM To: Ozer, Pam Cc: Josh Berkus; [email protected] Subject: Re: [PERFORM] Slow Query- Bad Row Estimate "Ozer, Pam" <[email protected]> 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 ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
