Postgres Pro
Downloads
Home   >   mailing lists

Re: Slow Query- Bad Row Estimate - Mailing list pgsql-performance

From Josh Berkus
Subject Re: Slow Query- Bad Row Estimate
Date
Msg-id 4CCB42A9.2090008@agliodbs.com
Whole thread Raw
In response to Re: Slow Query- Bad Row Estimate  ("Ozer, Pam" <pozer@automotive.com>)
Responses Re: Slow Query- Bad Row Estimate  ("Ozer, Pam" <pozer@automotive.com>)
List pgsql-performance
Tree view 
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
explanationof the default_stats work?  I don't think I completely understand what it means when you set it to 500
insteadof 1000? 

You're already at 1000?


--
                                  -- Josh Berkus
                                     PostgreSQL Experts Inc.
                                     http://www.pgexperts.com

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Slow Query- Bad Row Estimate
Next
From: "Ozer, Pam"
Date:
Subject: Re: Slow Query- Bad Row Estimate