Re: disk space usage enlarging despite vacuuming

Tzvetan Tzankov <ceco(at)noxis(dot)net> writes:
> I use debian package postgresql 7.3.2r1-2, it is set to vacuum every 5
> hours and once weekly (sunday) vacuum -f, aditionally there are some
> session tables which vacuum at 5 minutes, dispite this the disk usage
> enlarges with 300-400MB for about 2 days and in sundey with the full vacuum
> very few MB-s are recovered.

There isn't enough info here to really tell what's going on; you need to
look at the individual tables and indexes of the problem databases to
see where the space is going. (pg_class's relpages column will give
you the right data, if you vacuum first.)

A first guess is that the problem is index bloat, but that's really
theorizing in advance of the data...

regards, tom lane