2016-06-20 17:03 GMT+02:00 Scott Mead <sco...@openscg.com>: > > > On Mon, Jun 20, 2016 at 6:13 AM, Andreas Kretschmer < > andr...@a-kretschmer.de> 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
