Horton
Menu

Re: auto-vacuum questions

Alan Hodgson <ahodgson@simkin.ca>

View thread
From: Alan Hodgson <ahodgson@simkin.ca>
To: pgsql-general@postgresql.org
Date: 2008-05-08T17:58:47Z
Lists: pgsql-general 
On Thursday 08 May 2008, John Gateley <gateley@jriver.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