Yes. The default statistics target was at 1000. So that would be what the column was using correct? -----Original Message----- From: Josh Berkus [mailto:josh@xxxxxxxxxxxx] Sent: Friday, October 29, 2010 2:55 PM To: Ozer, Pam Cc: pgsql-performance@xxxxxxxxxxxxxx Subject: Re: Slow Query- Bad Row Estimate On 10/29/10 2:47 PM, Ozer, Pam wrote: > I had just analyzed the dealergroupgeochache table. Wow. Thank you. That did the trick. Can you give me an explanation of the default_stats work? I don't think I completely understand what it means when you set it to 500 instead of 1000? You're already at 1000? -- -- Josh Berkus PostgreSQL Experts Inc. http://www.pgexperts.com -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
