Re: Checkpoint gets stuck in mdsync

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Checkpoint gets stuck in mdsync
Дата
Msg-id 27041.1175783978@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Checkpoint gets stuck in mdsync  (Heikki Linnakangas <heikki@enterprisedb.com>)
Список pgsql-hackers
Heikki Linnakangas <heikki@enterprisedb.com> writes:
> My proposed fix is to make a copy of pendingOpsTable before entering the 
> loop. AbsorbFsyncRequest will put new requests to a fresh new 
> pendingOpsTable, while the mdsync loop will drain the copy. I'll write a 
> patch along those lines if there's no better ideas.

That sounds pretty ugly.  Perhaps better is a "cycle ID" field added to
the table entries, assigned from a counter that's bumped before entering
the fsync loop.  Then you could distinguish entries made before starting
the loop from those made after.  One fine point is to not let
AbsorbFsyncRequest change the cycle ID on a pre-existing entry ...
        regards, tom lane


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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Interaction of PITR backups andBulkoperationsavoiding WAL
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Bug in UTF8-Validation Code?