> William, > > You need to increase your fsm settings. The database is telling you it is > trying to store 177K+ pages, but you have only provided it with 20K. Since > these pages are cheap, I would set your fsm up with at least the following. > > max_fsm_pages 500000 > max_fsm_relations 5000 > > This should provide PostgreSQL with enough space to work. You still might > need to run one more vacuum full once you change the setting so that you > can recover the space that was lost due to your fsm begin to small. Yes he will need to run a vacuum full but I actually doubt he needs to increase his max_fsm_pages that much, he just needs to vacuum more. Joshua D. Drake
