Home > mailing lists

Re: VACUUM FULL for performance - Mailing list pgsql-general

From	Szymon Guz
Subject	Re: VACUUM FULL for performance
Date	October 7, 2010 13:33:55
Msg-id	AANLkTimVWoN3FC2B0ne=YAFv-KQHBZ9xgPkeE4z7xhPz@mail.gmail.com Whole thread Raw
In response to	Re: VACUUM FULL for performance (Devrim GÜNDÜZ <devrim@gunduz.org>)
Responses	Re: VACUUM FULL for performance (Bill Moran <wmoran@potentialtech.com>)
List	pgsql-general

2010/10/7 Devrim GÜNDÜZ <devrim@gunduz.org>

On Thu, 2010-10-07 at 17:38 +0600, AI Rumman wrote:
> MayVACUUM FULL on a table improve perfromance of the system?

No, it will make things worse.

That's not true, I'd rather say that it depends. The whole performance is not just about the vacuum full.

regards

Szymon

From: Leonardo Francalanci
Date: 07 October 2010, 13:29:55
Subject: Re: VACUUM FULL for performance

From: Bill Moran
Date: 07 October 2010, 13:40:08
Subject: Re: VACUUM FULL for performance