Re: max_fsm_pages
От | Scott Marlowe |
---|---|
Тема | Re: max_fsm_pages |
Дата | |
Msg-id | 1088715623.14882.6.camel@localhost.localdomain обсуждение исходный текст |
Ответ на | max_fsm_pages (<wespvp@syntegra.com>) |
Ответы |
Re: max_fsm_pages
|
Список | pgsql-general |
On Thu, 2004-07-01 at 11:45, wespvp@syntegra.com wrote: > If max_fsm_pages is too small and I have space not reclaimed by vacuum, if I > increase max_fsm_pages and restart postmaster, will the next VACUUM ANALYZE > relcaim all overlooked pages or must I do a VACUUM FULL? Let's say you have a table with 1,000 rows, but you've deleted 1,000,000 over the past year, and most of those are unclaimed. Regular vacuum will put those 900,000 odd pages into the FSM, and the database can use them. However, scans on this table will still be mostly reading empty space. So, to collapse the table back down to something reasonable, you'll need to do a vacuum full, then regular vacuums should keep things tight from then on.
В списке pgsql-general по дате отправления: