On 11/20/2016 04:51 AM, Job wrote:
> 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 of records in a day.
FYI, Postgres 8.4 is over two years past EOL.
>
> I noticed that only autovacuum seems not to be able to free unused space.
Do you run ANALYZE at any point in your procedure?
What are the steps in the load/delete cycle?
> 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
>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com