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
Дата: