Re: CheckpointStartLock starvation - Mailing list pgsql-hackers

From Tom Lane
Subject Re: CheckpointStartLock starvation
Date
Msg-id 28923.1175549572@sss.pgh.pa.us
Whole thread Raw
In response to Re: CheckpointStartLock starvation  (Heikki Linnakangas <heikki@enterprisedb.com>)
Responses Re: CheckpointStartLock starvation  (Heikki Linnakangas <heikki@enterprisedb.com>)
List pgsql-hackers
Heikki Linnakangas <heikki@enterprisedb.com> writes:
> Tom Lane wrote:
>> What sort of "wait for finish" mechanism do you have in mind?

> I was thinking of XactLockTableWait.

Ugh.  I don't think the bgwriter can participate in heavyweight-lockmgr
operations, or should become able to.

Nor will that work for prepared xacts --- you don't want to wait for the
eventual commit, only for PREPARE TRANSACTION to exit its critical
section.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Is this portable?
Next
From: Josh Berkus
Date:
Subject: Re: So are we calling it: Feature Freeze?