Re: R: Vacuum full: alternatives?

[Guillaume Lelarge <guillaume@xxxxxxxxxxxx>]

2016-06-20 17:03 GMT+02:00 Scott Mead <scottm@xxxxxxxxxxx>:

On Mon, Jun 20, 2016 at 6:13 AM, Andreas Kretschmer <andreas@xxxxxxxxxxxxxxx> wrote:

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

I believe that free space is only available to UPDATE, not INSERT.

No, it's available for both.

--

Guillaume.

  http://blog.guillaume.lelarge.info

  http://www.dalibo.com