From: | "JOUANIN Nicolas (44)" <nicolas(dot)jouanin(at)dgfip(dot)finances(dot)gouv(dot)fr> |
---|---|
To: | Guillaume Smet <guillaume(dot)smet(at)gmail(dot)com> |
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 11:27:07 |
Message-ID: | 4C34648B.1010103@dgfip.finances.gouv.fr |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<font size="-1"><font face="Arial">It seems to work fine (same
execution plan and less duration) after :<br>
- setting default_statistics_target to 100<br>
- full vacuum with analyze<br>
- reindexdb<br>
<br>
Thanks.<br>
</font></font><br>
<br>
-------- Message original --------<br>
Sujet : Re: [PERFORM] Two different execution plan for the same request<br>
De : Guillaume Smet <a class="moz-txt-link-rfc2396E" href="mailto:guillaume(dot)smet(at)gmail(dot)com"><guillaume(dot)smet(at)gmail(dot)com></a><br>
Pour : JOUANIN Nicolas (44)
<a class="moz-txt-link-rfc2396E" href="mailto:nicolas(dot)jouanin(at)dgfip(dot)finances(dot)gouv(dot)fr"><nicolas(dot)jouanin(at)dgfip(dot)finances(dot)gouv(dot)fr></a><br>
Copie à : Yeb Havinga <a class="moz-txt-link-rfc2396E" href="mailto:yebhavinga(at)gmail(dot)com"><yebhavinga(at)gmail(dot)com></a>,
<a class="moz-txt-link-abbreviated" href="mailto:pgsql-performance(at)postgresql(dot)org">pgsql-performance(at)postgresql(dot)org</a><br>
Date : 07/07/2010 10:59<br>
<blockquote
cite="mid:AANLkTimrF-p7o2iFzRcRFhH1hPbLT85SVoR6gxynKeRp(at)mail(dot)gmail(dot)com"
type="cite">
<pre wrap="">Hi Nicolas,
On Wed, Jul 7, 2010 at 10:47 AM, JOUANIN Nicolas (44)
<a class="moz-txt-link-rfc2396E" href="mailto:nicolas(dot)jouanin(at)dgfip(dot)finances(dot)gouv(dot)fr"><nicolas(dot)jouanin(at)dgfip(dot)finances(dot)gouv(dot)fr></a> wrote:
</pre>
<blockquote type="cite">
<pre wrap="">There were no modification made on the database except a restart yesterday evening and a vacuumdb --analyse ran at night.
</pre>
</blockquote>
<pre wrap=""><!---->
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
</pre>
</blockquote>
<br>
</body>
</html>
Attachment | Content-Type | Size |
---|---|---|
unknown_filename | text/html | 2.1 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Kevin Grittner | 2010-07-07 11:58:25 | Re: WAL partition overloaded--by autovacuum? |
Previous Message | Guillaume Smet | 2010-07-07 08:59:56 | Re: Two different execution plan for the same request |