Tzvetan Tzankov <ceco(at)noxis(dot)net> writes:
> hallo,
>
> 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.
It's probably index growth, which isn't fixed by VACUUM. Do a REINDEX
after the weekly VACUUM FULL and you should see that space reclaimed.
7.4 should fix this IIRC.
-Doug