| 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: | Whole Thread | Raw Message | 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 |