Hi,
How do I make the physical size of the DB smaller without doing a
full vacuum.
This might turn out to be counterproductive, as subsequent inserts
and updates will increase
the size of the physical database again, which might be expensive
depending on the underlying OS.
--
Heiko W.Rup
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 tabl
Hi List,
When auto vacuum is over the dead tuple are seems to get reduced, but
physical size of database do not decreases.
We are using Postgres 8.1.3 and this are the auto vacuum settings.
autovacuum = on # enable autovacuum subprocess?
autovacuum_naptime = 900#
