Re: Autovacuum help..
От | Francisco Reyes |
---|---|
Тема | Re: Autovacuum help.. |
Дата | |
Msg-id | cone.1154878879.713281.31808.1000@zoraida.natserv.net обсуждение исходный текст |
Ответ на | Autovacuum help.. (Sundar Narayanaswamy <sundar007@yahoo.com>) |
Ответы |
Re: Autovacuum help..
|
Список | pgsql-general |
Matthew T. O'Connor writes: > In many instances the default thresholds for autovacuum are too > conservative. You can try making it more aggressive and see what > happens, you can do this generally, or on a table specific basis. I think something is very wrong with the estimates I am getting back. After 3 times increasing the max_fsm_pages, every time I get the same error.. about needing to increase max_fsm_pages.. and always the error is recommending exactly the same number of additional fsm_pages. I see other threads with other people having simmilar problems. Going to see if I can find a resolution in the archives.
В списке pgsql-general по дате отправления: