Re: WAL format changes

Поиск
Список
Период
Сортировка
Искать
От
Heikki Linnakangas
Тема
Re: WAL format changes
Дата
Msg-id
4FDF7456.9010709@enterprisedb.com
Ответ на
Re: WAL format changes (Andres Freund)
Список
Дерево обсуждения
WAL format changes Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: WAL format changes Peter Eisentraut <peter_e@gmx.net>
Re: WAL format changes Andres Freund <andres@2ndquadrant.com>
Re: WAL format changes Andres Freund <andres@2ndquadrant.com>
Re: WAL format changes Robert Haas <robertmhaas@gmail.com>
Re: WAL format changes Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: WAL format changes Andres Freund <andres@2ndquadrant.com>
Re: WAL format changes Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: WAL format changes Andres Freund <andres@2ndquadrant.com>
Re: WAL format changes Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: WAL format changes Andres Freund <andres@2ndquadrant.com>
Re: WAL format changes Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: WAL format changes Andres Freund <andres@2ndquadrant.com>
Re: WAL format changes Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: WAL format changes Andres Freund <andres@2ndquadrant.com>
Re: WAL format changes Robert Haas <robertmhaas@gmail.com>
Re: WAL format changes Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: WAL format changes Simon Riggs <simon@2ndQuadrant.com>
Re: WAL format changes Fujii Masao <masao.fujii@gmail.com>
Re: WAL format changes Fujii Masao <masao.fujii@gmail.com>
Re: WAL format changes Fujii Masao <masao.fujii@gmail.com>
Re: WAL format changes Robert Haas <robertmhaas@gmail.com>
Re: WAL format changes Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: WAL format changes Alvaro Herrera <alvherre@commandprompt.com>
Re: WAL format changes Tom Lane <tgl@sss.pgh.pa.us>
Re: WAL format changes Amit Kapila <amit.kapila@huawei.com>
Re: WAL format changes Magnus Hagander <magnus@hagander.net>
Re: WAL format changes Fujii Masao <masao.fujii@gmail.com>
Re: WAL format changes Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: WAL format changes Robert Haas <robertmhaas@gmail.com>
Re: WAL format changes Greg Stark <stark@mit.edu>
On 18.06.2012 21:13, Andres Freund wrote:
> On Monday, June 18, 2012 08:08:14 PM Heikki Linnakangas wrote:
>> The page header contains an XLogRecPtr (LSN), so if we change it we'll
>> have to deal with pg_upgrade. I guess we could still keep XLogRecPtr
>> around as the on-disk representation, and convert between the 64-bit
>> integer and XLogRecPtr in PageGetLSN/PageSetLSN. I can try that out -
>> many xlog calculations would admittedly be simpler if it was an uint64.
> I am out of my depth here, not having read any of the relevant code, but
> couldn't we simply replace the lsn from disk with InvalidXLogRecPtr without
> marking the page dirty?
>
> There is the valid argument that you would loose some information when pages
> with hint bits are written out again, but on the other hand you would also
> gain the information that it was a hint-bit write...

Sorry, I don't understand that. Where would you "replace the LSN from 
disk with InvalidXLogRecPtr" ? (and no, it probably won't work ;-) )

--   Heikki Linnakangas  EnterpriseDB   http://www.enterprisedb.com

В списке pgsql-hackers по дате отправления
От: Robert Haas
Дата:
Сообщение: Re: WAL format changes
От: Peter Eisentraut
Дата:
Сообщение: Re: initdb and fsync
FAQ