Re: Vacuum thoughts - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Vacuum thoughts
Date
Msg-id 15880.1066685474@sss.pgh.pa.us
Whole thread Raw
In response to Re: Vacuum thoughts  (Christopher Browne <cbbrowne@acm.org>)
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Unicode upper() bug still present
Next
From: Tom Lane
Date:
Subject: So, are we going to bump catversion for beta5, or not?