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