Horton

Re: Wrong statistics for size of XLOG_SWITCH during pg_waldump.

movead.li@highgo.ca <movead.li@highgo.ca>

View thread View on postgr.es
From: "movead.li@highgo.ca" <movead.li@highgo.ca>
To: Horiguchi <horikyota.ntt@gmail.com>
Cc: andres <andres@anarazel.de>, michael <michael@paquier.xyz>, pgsql-hackers <pgsql-hackers@postgresql.org>, ahsan.hadi <ahsan.hadi@highgo.ca>
Date: 2020-10-16T09:39:58Z
Lists: pgsql-hackers

Attachments

>It looks to me "We can know that length by subtracting the LSN of
>XLOG_SWITCH from the next record's LSN so it doesn't add any
>information."
Sorry,maybe I miss this before.
But I think it will be better to show it clearly.

>So the length of <EMPTY> in this case is:
> 
>LOC(SEG A+1) - ReadRecPtr - LEN(short header) - LEN(XLOG_SWITCH)
Thanks, I should not have missed this and fixed.




Regards,
Highgo Software (Canada/China/Pakistan) 
URL : www.highgo.ca 
EMAIL: mailto:movead(dot)li(at)highgo(dot)ca

Commits

  1. pg_waldump: Fix bug in per-record statistics.