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(at)sss(dot)pgh(dot)pa(dot)us> wrote in message
news:7309(dot)1040338410(at)sss(dot)pgh(dot)pa(dot)us(dot)(dot)(dot)
> "HT" <htlevine(at)ebates(dot)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