On Mon, Jun 20, 2016 at 3: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
Are you sure that that is the case with pg_bulkload specifically? It bypasses the shared buffers, so it would not surprise me if it bypasses the free space map as well, and thus always appends its data to the end of the table. Cheers, Jeff -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
