Re: toast table growing indefinitely? Known
От | Christopher Kings-Lynne |
---|---|
Тема | Re: toast table growing indefinitely? Known |
Дата | |
Msg-id | 00c801c29a3f$7630ec10$6500a8c0@internal обсуждение исходный текст |
Ответ на | toast table growing indefinitely? Known problems? (Philip Warner <pjw@rhyme.com.au>) |
Ответы |
Re: toast table growing indefinitely? Known
Re: toast table growing indefinitely? Known |
Список | pgsql-hackers |
> Good call; they are still default (10000 pages) and we are seeing 26000 > pages per day being updated: > > NOTICE: Removed 102226 tuples in 26002 pages. > CPU 2.02s/1.87u sec elapsed 69.85 sec. > NOTICE: Pages 201819: Changed 26128, Empty 0; Tup 315227: Vac 102226, Keep > 0, UnUsed 393793. > Total CPU 9.57s/3.07u sec elapsed 189.32 sec. > > I've increased the value to 40000 since we have much busier days, and I'll > se what happens. Hang on - so when vacuum runs it knows exactly how many pages it cleaned up but if the fsm value is low, it doesn't help? Why don't we just automaticlaly set the FSM value to the max that vacuum has to clean up? Why don't we introduce: max_fsm_pages = auto or something? Chris
В списке pgsql-hackers по дате отправления: