> [EMAIL PROTECTED] > > > Peter Childs <[EMAIL PROTECTED]> writes: > > > On Fri, 30 May 2003, Tomas Szepe wrote: > > >> Trouble is, as the rows in the tables get deleted/inserted/updated > > >> (the frequency being a couple thousand rows per minute), the database > > >> is growing out of proportion in size. > > > > > Would more regular vacuum help. I think a vaccum every hour may do > > > the job. > > > > Also note that no amount of vacuuming will save you if the FSM is not > > large enough to keep track of all the free space. The default FSM > > settings, like all the other default settings in Postgres, are set up > > for a small installation. You'd probably need to raise them by at least > > a factor of 10 for this installation. > > Thanks, I'll try to tweak those settings and will let the list know how > things went.
Well, raising max_fsm_pages to 500000 seems to have solved the problem entirely. My thanks go to everyone who've offered their help. -- Tomas Szepe <[EMAIL PROTECTED]> ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
