Re: HELP? Postgres filling up disk

will do!  I'll let you know how it goes but it will be after xmas  cause we
can have no down-time right now.

thanks!

"Tom Lane" <tgl@sss.pgh.pa.us> wrote in message
news:7309.1040338410@sss.pgh.pa.us...
> "HT" <htlevine@ebates.com> writes:
> > $ ls -l 3828262123*
> > -rw-------   1 postgres postgres 1073741824 Dec 18 23:08 3828262123
> > -rw-------   1 postgres postgres 558899200 Dec 18 23:16 3828262123.1
>
> Okay, that looks more plausible.
>
> I think you need a VACUUM FULL to recover the wasted space in the master
> table, followed by more frequent plain VACUUMs to keep it from bloating.
> It's also almost certain that you need to increase the FSM parameters in
> postgresql.conf.  See recent discussions in the archives about sizing
> FSM properly.
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster