Yes. The default statistics target was at 1000. So that would be what the column was using correct?
-----Original Message----- From: Josh Berkus [mailto:j...@agliodbs.com] Sent: Friday, October 29, 2010 2:55 PM To: Ozer, Pam Cc: pgsql-performance@postgresql.org Subject: Re: [PERFORM] 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@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
