Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: full vacuum really slows down query
Date
Msg-id 7068.1212623068@sss.pgh.pa.us
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 
Jason Long <mailing.list@supernovasoftware.com> writes:
> 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.

> Would someone please comment as to why I would see a 15x slow down by
> only vacuuming the DB?

EXPLAIN ANALYZE of both cases might yield some insight.

            regards, tom lane

pgsql-general by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: Script errors on run
Next
From: Jason Long
Date:
Subject: Re: full vacuum really slows down query