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