WALInsertLock tuning
От
Simon Riggs
Тема
WALInsertLock tuning
Дата
Msg-id
BANLkTingB35r5Z3TDD5B2sajSbmB3sgAWg@mail.gmail.com
Список
Дерево обсуждения
WALInsertLock tuning Simon Riggs <simon@2ndQuadrant.com>
Re: WALInsertLock tuning Tom Lane <tgl@sss.pgh.pa.us>
Re: WALInsertLock tuning Simon Riggs <simon@2ndquadrant.com>
Re: WALInsertLock tuning Jeff Janes <jeff.janes@gmail.com>
Re: WALInsertLock tuning Simon Riggs <simon@2ndQuadrant.com>
Re: WALInsertLock tuning Robert Haas <robertmhaas@gmail.com>
Re: WALInsertLock tuning Simon Riggs <simon@2ndQuadrant.com>
Re: WALInsertLock tuning Bruce Momjian <bruce@momjian.us>
Re: WALInsertLock tuning Robert Haas <robertmhaas@gmail.com>
Re: WALInsertLock tuning Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: WALInsertLock tuning Simon Riggs <simon@2ndQuadrant.com>
Re: WALInsertLock tuning Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: WALInsertLock tuning Tom Lane <tgl@sss.pgh.pa.us>
Re: WALInsertLock tuning Simon Riggs <simon@2ndQuadrant.com>
Re: WALInsertLock tuning Robert Haas <robertmhaas@gmail.com>
Re: WALInsertLock tuning Simon Riggs <simon@2ndQuadrant.com>
Re: WALInsertLock tuning Fujii Masao <masao.fujii@gmail.com>
In earlier discussions of how to improve WALInsertLock contention, it was observed that we must zero each new page before we advance the WAL insertion point. http://postgresql.1045698.n5.nabble.com/Reworking-WAL-locking-td1983647.html IMHO the page zeroing is completely unnecessary, and replication works perfectly well without that (as a test of recovery logic). It is unnecessary because we already allow non-zeroed parts of WAL files, and provide a mechanism to detect stale data. The following trivial patch removes the page zeroing, which reduces the lock duration. Comments? -- Simon Riggs http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services
В списке pgsql-hackers по дате отправления
От: Kevin Grittner
Дата:
От: Alvaro Herrera
Дата:
