On Thu, 8 May 2008 10:58:47 -0700 Alan Hodgson <[EMAIL PROTECTED]> wrote:
> On Thursday 08 May 2008, John 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 <[EMAIL PROTECTED]> -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general