Autovacuum and frequent pg_bulkload - Mailing list pgsql-general

From Job
Subject Autovacuum and frequent pg_bulkload
Date
Msg-id 88EF58F000EC4B4684700C2AA3A73D7A08054EAEBAE1@W2008DC01.ColliniConsulting.lan
Whole thread Raw
Responses Re: Autovacuum and frequent pg_bulkload  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Hello,

i use PostgreSql 8.4.22 and two times a day, i import logs wth pg_bulkload and i delete old data. I move some millions
ofrecords in a day. 

I noticed that only autovacuum seems not to be able to free unused space.
I need a periodical vacuum full but this operations takes many hours.

Do you think it is due to pk_bulkload that is not able to "see" free-marked space to use when loading new data?

Thank you,
/F

pgsql-general by date:

Previous
From: Thomas Kellerer
Date:
Subject: Re: Strict min and max aggregate functions
Next
From: Adrian Klaver
Date:
Subject: Re: Autovacuum and frequent pg_bulkload