So is it no use running vacuumdb --all --analyze --full as fsm map is full?
-Arvind S On Sun, Jun 7, 2009 at 4:24 AM, S Arvind <arvindw...@gmail.com> wrote: > Thanks Tom, > So do i have to increase the max_fsm_relation based on (Average_no_relation > per db * number of db)? if so it will be very high since in our one db > server we have 200 db with average 800 tables in each db. What is the value > we have to give for this kind of server? > > -Arvind S > > > > > On Sun, Jun 7, 2009 at 4:15 AM, Tom Lane <t...@sss.pgh.pa.us> wrote: > >> S Arvind <arvindw...@gmail.com> writes: >> > But there nearly only 300 tables in that db. Is the free space map is >> per >> > DB or for all DB. Can i know the reason of this problem? >> >> It's across all DBs in the installation. >> >> regards, tom lane >> > >
