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.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
