From: | "Ozer, Pam" <pozer(at)automotive(dot)com> |
---|---|
To: | "Josh Berkus" <josh(at)agliodbs(dot)com> |
Cc: | <pgsql-performance(at)postgresql(dot)org> |
Subject: | Re: Slow Query- Bad Row Estimate |
Date: | 2010-10-29 21:55:59 |
Message-ID: | 216FFB77CBFAEE4B8EE4DF0A939FF1D101835A@mail-001.corp.automotive.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
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(at)agliodbs(dot)com]
Sent: Friday, October 29, 2010 2:55 PM
To: Ozer, Pam
Cc: pgsql-performance(at)postgresql(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2010-10-29 22:03:25 | Re: Slow Query- Bad Row Estimate |
Previous Message | Josh Berkus | 2010-10-29 21:54:49 | Re: Slow Query- Bad Row Estimate |