Thread: BUG #8728: Toast table much larger on replica
(apologies for lack of proper threading, but I never got an e-mail from my form submission--checked spam folder and everything) I took another look at the cluster, and the extra extents in question all look like this in hexdump: 00000000 00 00 00 00 00 00 00 00 00 00 00 00 18 00 00 20 |............... | 00000010 00 20 04 20 00 00 00 00 00 00 00 00 00 00 00 00 |. . ............| 00000020 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 |................| * 00002000 00 00 00 00 00 00 00 00 00 00 00 00 18 00 00 20 |............... | 00002010 00 20 04 20 00 00 00 00 00 00 00 00 00 00 00 00 |. . ............| 00002020 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 |................| * 00004000 00 00 00 00 00 00 00 00 00 00 00 00 18 00 00 20 |............... | We're actually investigating a separate WAL-E issue that may have led to missing files (possibly including visibility maps) when originally setting up the base backup. I don't think that directly caused these extra files, but I'm bringing it up since it may be relevant here.
Waciek, * Maciek Sakrejda (m.sakrejda@gmail.com) wrote: > (apologies for lack of proper threading, but I never got an e-mail from my > form submission--checked spam folder and everything) My apologies, but we had an issue with the form submission page for a bit. If anyone else submitted a bug and it did not show up- please re-submit. Thanks, Stephen
Thanks, Stephen. To clarify, the bug itself did show up in the list archives: http://www.postgresql.org/message-id/E1W0JPC-00012b-I1@wrigleys.postgresql.org I just never got an e-mail regarding the bug that I could follow up on.