Re: partial VACUUM FULL - Mailing list pgsql-general

From Joe Conway
Subject Re: partial VACUUM FULL
Date
Msg-id 40610EAD.60307@joeconway.com
Whole thread Raw
In response to Re: partial VACUUM FULL  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: partial VACUUM FULL
List pgsql-general
Tom Lane wrote:
> This is completely untrue.  Increasing vacuum_mem will likely make
> things faster on large tables (by avoiding the need for multiple passes
> over the indexes).  It will not change the end result though.

I can attest to that, based on very recent empirical evidence. On a 28
million row table, I saw something like 33% speed-up in going from 256MB
to 320MB for vacuum_mem.

Joe


pgsql-general by date:

Previous
From: glenn
Date:
Subject: ole db
Next
From: Joseph Shraibman
Date:
Subject: Re: partial VACUUM FULL