Re: CommitDelay performance improvement

Поиск
Список
Период
Сортировка
От Philip Warner
Тема Re: CommitDelay performance improvement
Дата
Msg-id 3.0.5.32.20010224145942.03246e80@mail.rhyme.com.au
обсуждение исходный текст
Ответ на CommitDelay performance improvement  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
At 11:32 23/02/01 -0500, Tom Lane wrote:
>Looking at the XLOG stuff, I notice that we already have a field
>(logRec) in the per-backend PROC structures that shows whether a
>transaction is currently in progress with at least one change made
>(ie at least one XLOG entry written).

Would it be worth adding a field 'waiting for fsync since xxx', so the
second process can (a) log that it is expecting someone else to FSYNC (for
perf stats, if we want them), and (b) wait for (xxx + delta)ms/us etc?




----------------------------------------------------------------
Philip Warner                    |     __---_____
Albatross Consulting Pty. Ltd.   |----/       -  \
(A.B.N. 75 008 659 498)          |          /(@)   ______---_
Tel: (+61) 0500 83 82 81         |                 _________  \
Fax: (+61) 0500 83 82 82         |                 ___________ |
Http://www.rhyme.com.au          |                /           \|                                |    --________--
PGP key available upon request,  |  /
and from pgp5.ai.mit.edu:11371   |/


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

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: RE: beta5 ...
Следующее
От: "Lawrence M. Kagan"
Дата:
Сообщение: Where is locking done?