Re: Disc space - UnUsed tuples

"Rune" <rune(at)inpoc(dot)com> writes:
> I have a database with a table where new tuples are often added and then
> updated. I get around 50000 new inserts every day, and every single tuple
> gets an update one or more times. This I think is the reason that the
> database takes up a lot more disc space then the actually data really need
> (UnUsed tuples), and I need to free space. The database needs to run 24
> hours a day, hence I cannot run vaccuum full to free space. My disc is
> getting full and I sure would have appreciated it if someone could give me a
> hint on what to do ?!?

Run regular vacuum more often, and/or boost your FSM parameters (in
postgresql.conf). You can find plenty of discussion of this in the
archives ...

regards, tom lane