Re: db growing out of proportion - Mailing list pgsql-bugs

From Tomas Szepe
Subject Re: db growing out of proportion
Date
Msg-id 20030613053459.GB23789@louise.pinerecords.com
Whole thread Raw
In response to Re: db growing out of proportion  (Tomas Szepe <szepe@pinerecords.com>)
List pgsql-bugs
> [szepe@pinerecords.com]
>
> > Peter Childs <blue.dragon@blueyonder.co.uk> 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 <szepe@pinerecords.com>

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: PostgreSQL client has problems when libbind is installed
Next
From: Serge Obeuf
Date:
Subject: Re: pg_dumpall not working in batch