On Thu, 2004-07-01 at 11:45, [EMAIL PROTECTED] 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. ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match