| From: | Guillaume Smet <guillaume(dot)smet(at)gmail(dot)com> |
|---|---|
| To: | "JOUANIN Nicolas (44)" <nicolas(dot)jouanin(at)dgfip(dot)finances(dot)gouv(dot)fr> |
| Cc: | Yeb Havinga <yebhavinga(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Two different execution plan for the same request |
| Date: | 2010-07-07 08:59:56 |
| Message-ID: | AANLkTimrF-p7o2iFzRcRFhH1hPbLT85SVoR6gxynKeRp@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Hi Nicolas,
On Wed, Jul 7, 2010 at 10:47 AM, JOUANIN Nicolas (44)
<nicolas(dot)jouanin(at)dgfip(dot)finances(dot)gouv(dot)fr> wrote:
> There were no modification made on the database except a restart yesterday evening and a vacuumdb --analyse ran at night.
It's not really surprising considering you probably kept the
default_statistics_target to 10 (it's the default in 8.3).
Consider raising it to 100 in your postgresql.conf (100 is the default
for newer versions), then reload, and run a new ANALYZE.
You might need to set it higher on specific columns if you have a lot
of data and your data distribution is weird.
And, btw, please upgrade to the latest 8.3.x.
HTH
--
Guillaume
| From | Date | Subject | |
|---|---|---|---|
| Next Message | JOUANIN Nicolas (44) | 2010-07-07 11:27:07 | Re: Two different execution plan for the same request |
| Previous Message | Yeb Havinga | 2010-07-07 08:59:23 | Re: Two different execution plan for the same request |