Re: Vacuum thoughts

Christopher Browne <cbbrowne@acm.org> writes:
> How about a "flip side" for this...
> VACUUM CACHE;

> This new operation vacuums only those pages of relations that are in
> cache.

This might conceivably be a useful behavior (modulo the problem of
fixing index entries) ... but I think we'd not want to expose it as
an actual VACUUM option.  If we were going to do something like that,
it should likely be done by an invisible automatic vacuum daemon,
more like checkpoints ...

			regards, tom lane