Postgres Pro
Downloads
Home   >   mailing lists

Re: R: Vacuum full: alternatives? - Mailing list pgsql-general

From Andreas Kretschmer
Subject Re: R: Vacuum full: alternatives?
Date
Msg-id 5767C1B9.2040200@a-kretschmer.de
Whole thread Raw
In response to R: Vacuum full: alternatives?  (Job <Job@colliniconsulting.it>)
Responses Re: R: Vacuum full: alternatives?  (Melvin Davidson <melvin6925@gmail.com>)
Re: R: Vacuum full: alternatives?  (Jeff Janes <jeff.janes@gmail.com>)
Re: R: Vacuum full: alternatives?  (Scott Mead <scottm@openscg.com>)
List pgsql-general
Tree view 

Am 20.06.2016 um 11:43 schrieb Job:
> Hi Andreas,
>
>> I would suggest run only autovacuum, and with time you will see a not
>> more growing table. There is no need for vacuum full.
> So new record, when will be pg_bulkloaded, will replace "marked-free" location?


exactly, that's the task for vacuum


Andreas

pgsql-general by date:

Previous
From: Robert Wysocki
Date:
Subject: Re: R: Vacuum full: alternatives?
Next
From: Rakesh Kumar
Date:
Subject: Re: R: Vacuum full: alternatives?