Gauri Kanekar wrote:
Hi List,
When auto vacuum is over the dead tuple are seems to get reduced, but
physical size of database do not decreases.
It won't necessarily. An ordinary vacuum just keeps track of old rows
that can be cleared and re-used. A "vacuum full" is needed to compact
the table.
If you are running a normal vacuum often enough then the size of the
database should remain about the same (unless you insert more rows of
course).
--
Richard Huxton
Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
