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
