Re: [GENERAL] Vacuum suggesting doubling of max_fsm_pages

2006-04-27 Thread Vivek Khera
On Apr 27, 2006, at 11:06 AM, Kenneth Downs wrote:I've got a test database that is going live.  During development I have not vacuum'd much, so to get started I did "Vacuum verbose analyze". you probably really do have a lot of spare space in the files.  i'd recommend vacuum full if you can, to com

[GENERAL] Vacuum suggesting doubling of max_fsm_pages

2006-04-27 Thread Kenneth Downs
Hi folks I'm hoping somebody can demystify something for me. I've got a test database that is going live. During development I have not vacuum'd much, so to get started I did "Vacuum verbose analyze". At the end of the process it told me that vacuum needed max_fsm_pages to be set at about 2