Autovacuum and frequent pg_bulkload

Поиск
Список
Период
Сортировка
От Job
Тема Autovacuum and frequent pg_bulkload
Дата
Msg-id 88EF58F000EC4B4684700C2AA3A73D7A08054EAEBAE1@W2008DC01.ColliniConsulting.lan
обсуждение исходный текст
Ответы Re: Autovacuum and frequent pg_bulkload  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список 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 по дате отправления:

Предыдущее
От: Thomas Kellerer
Дата:
Сообщение: Re: Strict min and max aggregate functions
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Autovacuum and frequent pg_bulkload