Re: auto-vacuum questions

From: Alan Hodgson <ahodgson(at)simkin(dot)ca>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: auto-vacuum questions
Date: 2008-05-08 17:58:47
Message-ID: 200805081058.50854@hal.medialogik.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thursday 08 May 2008, John Gateley <gateley(at)jriver(dot)com> wrote:
> But the new database, mydbtest, always has slow queries.
> I run an analyze and they speed up.

Do the query plans actually change, or are you just seeing caching effects
from running the analyze?

--
Alan

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John Gateley 2008-05-08 18:10:12 Re: auto-vacuum questions
Previous Message Dan Myers 2008-05-08 17:20:07 Re: Using a composite SQL type in C