Re: Attempt to consolidate reading of XLOG page

Поиск
Список
Период
Сортировка
Искать
От
Antonin Houska
Тема
Re: Attempt to consolidate reading of XLOG page
Дата
Msg-id
50470.1574672520@antos
Ответ на
Список
Дерево обсуждения
Attempt to consolidate reading of XLOG page Antonin Houska <ah@cybertec.at>
Re: Attempt to consolidate reading of XLOG page Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>
Re: Attempt to consolidate reading of XLOG page Antonin Houska <ah@cybertec.at>
Re: Attempt to consolidate reading of XLOG page Michael Paquier <michael@paquier.xyz>
Re: Attempt to consolidate reading of XLOG page Antonin Houska <ah@cybertec.at>
Re: Attempt to consolidate reading of XLOG page Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Attempt to consolidate reading of XLOG page Antonin Houska <ah@cybertec.at>
Re: Attempt to consolidate reading of XLOG page Antonin Houska <ah@cybertec.at>
Re: Attempt to consolidate reading of XLOG page Robert Haas <robertmhaas@gmail.com>
Re: Attempt to consolidate reading of XLOG page Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Attempt to consolidate reading of XLOG page Robert Haas <robertmhaas@gmail.com>
Re: Attempt to consolidate reading of XLOG page Antonin Houska <ah@cybertec.at>
Re: Attempt to consolidate reading of XLOG page Thomas Munro <thomas.munro@gmail.com>
Re: Attempt to consolidate reading of XLOG page Antonin Houska <ah@cybertec.at>
Re: Attempt to consolidate reading of XLOG page Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Attempt to consolidate reading of XLOG page Antonin Houska <ah@cybertec.at>
Re: Attempt to consolidate reading of XLOG page Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Attempt to consolidate reading of XLOG page Antonin Houska <ah@cybertec.at>
Re: Attempt to consolidate reading of XLOG page Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Attempt to consolidate reading of XLOG page Alvaro Herrera from 2ndQuadrant <alvherre@alvh.no-ip.org>
Re: Attempt to consolidate reading of XLOG page Antonin Houska <ah@cybertec.at>
Re: Attempt to consolidate reading of XLOG page Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Attempt to consolidate reading of XLOG page Antonin Houska <ah@cybertec.at>
Re: Attempt to consolidate reading of XLOG page Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Attempt to consolidate reading of XLOG page Antonin Houska <ah@cybertec.at>
Re: Attempt to consolidate reading of XLOG page Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Attempt to consolidate reading of XLOG page Tom Lane <tgl@sss.pgh.pa.us>
Re: Attempt to consolidate reading of XLOG page Antonin Houska <ah@cybertec.at>
Re: Attempt to consolidate reading of XLOG page Antonin Houska <ah@cybertec.at>
Re: Attempt to consolidate reading of XLOG page Michael Paquier <michael@paquier.xyz>
Re: Attempt to consolidate reading of XLOG page Antonin Houska <ah@cybertec.at>
Re: Attempt to consolidate reading of XLOG page Michael Paquier <michael@paquier.xyz>
Re: Attempt to consolidate reading of XLOG page Antonin Houska <ah@cybertec.at>
Re: Attempt to consolidate reading of XLOG page Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Attempt to consolidate reading of XLOG page Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Attempt to consolidate reading of XLOG page Michael Paquier <michael@paquier.xyz>
Re: Attempt to consolidate reading of XLOG page Michael Paquier <michael@paquier.xyz>
Re: Attempt to consolidate reading of XLOG page Antonin Houska <ah@cybertec.at>
Re: Attempt to consolidate reading of XLOG page Michael Paquier <michael@paquier.xyz>
Re: Attempt to consolidate reading of XLOG page Michael Paquier <michael@paquier.xyz>
Re: Attempt to consolidate reading of XLOG page Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Attempt to consolidate reading of XLOG page Michael Paquier <michael@paquier.xyz>
Re: Attempt to consolidate reading of XLOG page Antonin Houska <ah@cybertec.at>
Re: Attempt to consolidate reading of XLOG page Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Attempt to consolidate reading of XLOG page Michael Paquier <michael@paquier.xyz>
Re: Attempt to consolidate reading of XLOG page Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Attempt to consolidate reading of XLOG page Antonin Houska <ah@cybertec.at>
Re: Attempt to consolidate reading of XLOG page Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Attempt to consolidate reading of XLOG page Michael Paquier <michael@paquier.xyz>
Re: Attempt to consolidate reading of XLOG page Antonin Houska <ah@cybertec.at>
Re: Attempt to consolidate reading of XLOG page Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Attempt to consolidate reading of XLOG page Antonin Houska <ah@cybertec.at>
Re: Attempt to consolidate reading of XLOG page Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Attempt to consolidate reading of XLOG page Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Attempt to consolidate reading of XLOG page Antonin Houska <ah@cybertec.at>
Re: Attempt to consolidate reading of XLOG page Antonin Houska <ah@cybertec.at>
Re: Attempt to consolidate reading of XLOG page Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: Attempt to consolidate reading of XLOG page Antonin Houska <ah@cybertec.at>
Re: Attempt to consolidate reading of XLOG page Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: Attempt to consolidate reading of XLOG page Antonin Houska <ah@cybertec.at>
Re: Attempt to consolidate reading of XLOG page Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Attempt to consolidate reading of XLOG page Haribabu Kommi <kommi.haribabu@gmail.com>
Alvaro Herrera  wrote:

> On 2019-Nov-22, Antonin Houska wrote:
> 
> > As I pointed out in
> > 
> > https://www.postgresql.org/message-id/88183.1574261429%40antos
> > 
> > seg.ws_off only replaced readOff in XLogReaderState. So we should only update
> > ws_off where readOff was updated before commit 709d003. This does happen in
> > ReadPageInternal (see HEAD) and I see no reason for the final patch to update
> > ws_off anywhere else.
> 
> Oh you're right.
> 
> I see no reason to leave ws_off.  We can move that to XLogReaderState; I
> did that here.  We also need the offset in WALReadError, though, so I
> added it there too.  Conceptually it seems clearer to me this way.
> 
> What do you think of the attached?

It looks good to me. Attached is just a fix of a minor problem in error
reporting that Michael pointed out earlier.

> BTW I'm not clear what errors can pread()/pg_pread() report that do not
> set errno.  I think lines 1083/1084 of WALRead are spurious now.

All I can say is that the existing calls of pg_pread() do not clear errno, so
you may be right. I'd appreciate more background about the "partial read" that
Michael mentions here:

https://www.postgresql.org/message-id/20191125033048.GG37821%40paquier.xyz

-- 
Antonin Houska
Web: https://www.cybertec-postgresql.com

В списке pgsql-hackers по дате отправления
От: Amit Langote
Дата:
От: Suraj Kharage
Дата:
Сообщение: Re: backup manifests
FAQ