On Thu, 8 May 2008 10:58:47 -0700
Alan Hodgson <ahodgson@simkin.ca> wrote:

> 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?

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@jriver.com>

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