Re: Two different execution plan for the same request

From: Matthew Wakeling <matthew(at)flymine(dot)org>
To: "JOUANIN Nicolas (44)" <nicolas(dot)jouanin(at)dgfip(dot)finances(dot)gouv(dot)fr>
Cc: Guillaume Smet <guillaume(dot)smet(at)gmail(dot)com>, 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 12:34:18
Message-ID: alpine.DEB.2.00.1007071333430.2534@aragorn.flymine.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Wed, 7 Jul 2010, JOUANIN Nicolas (44) wrote:
> It seems to work fine (same execution plan and less duration) after :
>  - setting default_statistics_target to 100
>  - full vacuum with analyze

Don't do VACUUM FULL.

Matthew

--
I suppose some of you have done a Continuous Maths course. Yes? Continuous
Maths? <menacing stares from audience> Whoah, it was like that, was it!
-- Computer Science Lecturer

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Merlin Moncure 2010-07-07 13:14:25 Re: Two "equivalent" WITH RECURSIVE queries, one of them slow.
Previous Message Kevin Grittner 2010-07-07 11:58:25 Re: WAL partition overloaded--by autovacuum?