Re: Remove xmin and cmin from frozen tuples

From: Pailloncy Jean-Gerard <jg(at)rilk(dot)com>
To: Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Remove xmin and cmin from frozen tuples
Date: 2005-09-02 17:21:23
Message-ID: 35A8B239-F1AE-472B-8D07-670F8FC33CE7@rilk.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> [skip]

> happening in the bgwriter's inner loop. Even more to the point, you
> can't do such changes without getting a superexclusive lock on the
> page
> (not only locked, but no one else has it pinned), which is a real
> nonstarter for the bgwriter, both for performance and possible
> deadlock
> issues.
Hi Tom,

I do not want to discuss in deep the place to do this job, it is
really over my head.

But, you said you need a "super-exclusive lock", and I wonder if a
wait-free algorithm would be good for pg in a general manner.

I have given some references about it already on the list.
http://archives.postgresql.org/pgsql-hackers/2005-02/msg00263.php

Cordialement,
Jean-Gérard Pailloncy

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2005-09-02 17:40:04 Re: Two different defs of MAX_TUPLES_PER_PAGE
Previous Message AgentM 2005-09-02 17:11:21 Re: Proof of concept COLLATE support with patch