Re: db growing out of proportion

> [tgl(at)sss(dot)pgh(dot)pa(dot)us]
>
> Peter Childs <blue(dot)dragon(at)blueyonder(dot)co(dot)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.

--
Tomas Szepe <szepe(at)pinerecords(dot)com>