Postgres Pro
Downloads
Home   >   mailing lists

Re: full vacuum really slows down query - Mailing list pgsql-general

From Joshua D. Drake
Subject Re: full vacuum really slows down query
Date
Msg-id 1212621063.12052.388.camel@jd-laptop
Whole thread Raw
In response to full vacuum really slows down query  (Jason Long <mailing.list@supernovasoftware.com>)
Responses Re: full vacuum really slows down query  (Jason Long <mailing.list@supernovasoftware.com>)
List pgsql-general
Tree view 

On Wed, 2008-06-04 at 17:02 -0500, Jason Long wrote:
> I have a query that takes 2 sec if I run it from a freshly restored
> dump.  If I run a full vacuum on the database it then takes 30 seconds.

If you run it a second time after the vacuum full?

Joshua D. Drake

pgsql-general by date:

Previous
From: Ralph Smith
Date:
Subject: Re: Script errors on run
Next
From: "Gregory Williamson"
Date:
Subject: Re: Script errors on run