On Thu, 8 May 2008 10:58:47 -0700 Alan Hodgson <ahodgson@xxxxxxxxx> wrote: > On Thursday 08 May 2008, John Gateley <gateley@xxxxxxxxxx> 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@xxxxxxxxxx>
