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)
Список
Дерево обсуждения
Checkpoint gets stuck in mdsync Heikki Linnakangas <heikki@enterprisedb.com>
Re: Checkpoint gets stuck in mdsync ITAGAKI Takahiro <itagaki.takahiro@oss.ntt.co.jp>
Re: Checkpoint gets stuck in mdsync Heikki Linnakangas <heikki@enterprisedb.com>
Re: Checkpoint gets stuck in mdsync Heikki Linnakangas <heikki@enterprisedb.com>
Re: Checkpoint gets stuck in mdsync Tom Lane <tgl@sss.pgh.pa.us>
Heikki Linnakangas  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
Дата:
От: Tom Lane
Дата:
FAQ