Re: Recommendation to run vacuum FULL in parallel - Mailing list pgsql-general

From rihad
Subject Re: Recommendation to run vacuum FULL in parallel
Date
Msg-id a04bde8b-867f-1daf-08c7-dd9bb6263cb3@mail.ru
Whole thread Raw
In response to Re: Recommendation to run vacuum FULL in parallel  (Michael Lewis <mlewis@entrata.com>)
Responses Re: Recommendation to run vacuum FULL in parallel  (Perumal Raj <perucinci@gmail.com>)
Re: Recommendation to run vacuum FULL in parallel  ("Peter J. Holzer" <hjp-pgsql@hjp.at>)
List pgsql-general
> And future updates can reuse it, too (an update is very similar to an
> insert+delete).


Hm, then it's strange our DB takes 6 times as much space compared to 
freshly restored one (only public schema is considered).

> Not if autovacuum has a chance to run between updates.

Ours is run regularly, although we had to tweak it down not to interfere 
with normal database activity, so it takes several hours each run on the 
table. We did that by setting autovacuum_vacuum_scale_factor = 0.05 from 
default 0.2.



pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Move vs. copy table between databases that share a tablespace?
Next
From: Lou Tseng
Date:
Subject: Lingering replication slots