Re: auto-vacuum questions

On Thu, 8 May 2008 10:58:47 -0700
Alan Hodgson <ahodgson@[EMAIL PROTECTED]
> wrote:

> On Thursday 08 May 2008, John Gateley <gateley@[EMAIL PROTECTED]
> 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?

The query plans actually change. I'm pretty sure that the auto-vacuum
wasn't happening, I'm going to test this tomorrow morning with
a fresh copy.

Thanks,

j
-- 
John Gateley <gateley@[EMAIL PROTECTED]
>

-- 
Sent via pgsql-general mailing list (pgsql-general@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general