Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Alternative for vacuuming queue-like tables
- From: Vivek Khera <vivek(at)khera(dot)org>
- To: Postgres general mailing list <pgsql-general(at)postgresql(dot)org>
- Subject: Re: Alternative for vacuuming queue-like tables
- Date: Fri, 28 Apr 2006 10:52:12 -0400
On Apr 28, 2006, at 9:32 AM, Csaba Nagy wrote:
I'm not sure how this operation can work in the presence of other long running transactions which did not touch the queue table yet, but it actually does work, I can confirm that. Is it violating MVCC maybe ?
It sounds like it does potentially violate mvcc, but I haven't thought hard about it. It also has the advantage that it rebuilds your indexes during the clustering.
And a convenient feature is that you just define those CLUSTER statements once, then whenever you need it, just run "CLUSTER;" all by itself and all tables previously defined as clustered will be re- clustered on the specified index.
- References:
- Re: Alternative for vacuuming queue-like tables
- From: kmh496
- Re: Alternative for vacuuming queue-like tables
- From: Csaba Nagy
- Re: Alternative for vacuuming queue-like tables
- Prev by Date: Re: Installing PostgreSQL on Win 2003 R2 64-bit
- Next by Date: Postmaster process on port 10000
- Previous by thread: Re: Alternative for vacuuming queue-like tables
- Next by thread: Re: Alternative for vacuuming queue-like tables
- Indexes: