BUG #8728: Toast table much larger on replica - Mailing list pgsql-bugs

From Maciek Sakrejda
Subject BUG #8728: Toast table much larger on replica
Date
Msg-id CAOtHd0D1Q06rMDcMiXFTAyXUPbYKQGHBYL5-qNuRK5CX-66bwg@mail.gmail.com
Whole thread Raw
Responses Re: BUG #8728: Toast table much larger on replica
List pgsql-bugs
(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.

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #8821: pg_trgm segfault with Turkish locale database
Next
From: Stephen Frost
Date:
Subject: Re: BUG #8728: Toast table much larger on replica