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