Home > mailing lists

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

From	Nathan Boley
Subject	Re: full vacuum really slows down query
Date	June 8, 2008 20:40:08
Msg-id	6fa3b6e20806081339h1a8d3905s80bc484088eab97e@mail.gmail.com Whole thread Raw
In response to	full vacuum really slows down query (Jason Long <jason@octgsoftware.com>)
List	pgsql-general

Tree view

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

What do the two plans look like? Can you post the explains?

-Nathan

pgsql-general by date:

From: Peter Eisentraut
Date: 08 June 2008, 20:27:28
Subject: Re: libpq.so.4

From: Devrim GÜNDÜZ
Date: 08 June 2008, 21:29:00
Subject: Re: libpq.so.4

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

Previous

Next