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" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> "HT" <[EMAIL PROTECTED]> 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



---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly

Reply via email to