Re: VACUUM FULL for performance

From: Szymon Guz <mabewlun(at)gmail(dot)com>
To: Devrim GÜNDÜZ <devrim(at)gunduz(dot)org>
Cc: AI Rumman <rummandba(at)gmail(dot)com>, pgsql-general General <pgsql-general(at)postgresql(dot)org>
Subject: Re: VACUUM FULL for performance
Date: 2010-10-07 13:33:38
Message-ID: AANLkTimVWoN3FC2B0ne=YAFv-KQHBZ9xgPkeE4z7xhPz@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

2010/10/7 Devrim GÜNDÜZ <devrim(at)gunduz(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bill Moran 2010-10-07 13:39:58 Re: VACUUM FULL for performance
Previous Message Leonardo Francalanci 2010-10-07 13:29:45 Re: VACUUM FULL for performance