Re: Vacuum thoughts

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Christopher Browne <cbbrowne(at)acm(dot)org>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Vacuum thoughts
Date: 2003-10-20 21:31:14
Message-ID: 15880.1066685474@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Christopher Browne <cbbrowne(at)acm(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2003-10-20 21:35:20 So, are we going to bump catversion for beta5, or not?
Previous Message Tom Lane 2003-10-20 21:15:41 Re: Unicode upper() bug still present