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