Re: CheckpointStartLock starvation

Поиск
Список
Период
Сортировка
От Heikki Linnakangas
Тема Re: CheckpointStartLock starvation
Дата
Msg-id 461216A0.1090700@enterprisedb.com
обсуждение исходный текст
Ответ на Re: CheckpointStartLock starvation  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: CheckpointStartLock starvation  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Tom Lane wrote:
> 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.

Oh, good point.

I suppose we could just poll and sleep, checkpoint is a heavy operation 
anyway so a little delay wouldn't hurt.

> 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.

PREPARE TRANSACTION wouldn't set the flag in MyProc; there's no clog 
changes to protect from at that point. It would be set in 
RecordTransactionCommitPrepared when we're really committing. Just like 
we use the CheckpointStartLock today.

--   Heikki Linnakangas  EnterpriseDB   http://www.enterprisedb.com


В списке pgsql-hackers по дате отправления:

Предыдущее
От: "Zeugswetter Andreas ADI SD"
Дата:
Сообщение: Re: Modifying TOAST thresholds
Следующее
От: "Marko Kreen"
Дата:
Сообщение: Re: PL/Python warnings in CVS HEAD