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
