Horton

Re: Decent VACUUM (was: Buglist)

Manfred Koizar <mkoi-pg@aon.at>

View thread View on postgr.es
From: Manfred Koizar <mkoi-pg@aon.at>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Vivek Khera <khera@kcilink.com>, pgsql-general@postgresql.org, pgsql-hackers@postgresql.org
Date: 2003-08-21T22:24:39Z
Lists: pgsql-hackers, pgsql-general 
On Thu, 21 Aug 2003 17:56:02 -0400, Tom Lane <tgl@sss.pgh.pa.us>
wrote:
>Conceivably it could be a win, though,
>if you could do frequent "vacuum decent"s and only a full-scan vacuum
>once in awhile (once a day maybe).

That's what I had in mind; similar to the current situation where you
can avoid expensive VACUUM FULL by doing lazy VACUUM frequently
enough.

Servus
 Manfred