Re: Non-emergency patch for bug #17679
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Andres Freund <andres@anarazel.de>
Cc: pgsql-hackers@lists.postgresql.org, Robert Haas <robertmhaas@gmail.com>
Date: 2022-11-08T20:40:43Z
Lists: pgsql-hackers
Andres Freund <andres@anarazel.de> writes: > On 2022-11-08 11:28:08 -0500, Tom Lane wrote: >> Hence, the attached reverts everything 4ab5dae94 did to this function, >> and most of 0e758ae89 too, and instead makes IsBinaryUpgrade an >> additional reason to take the immediate-unlink path. > I wonder if it's worth aiming slightly higher. There's plenty duplicated code > between the first segment handling and the loop body. Perhaps the if at the > top just should decide whether to unlink the first segment or not, and we then > check that in the body of the loop for segno == 0? I don't care for that. I think the point here is precisely that we want behavior A for the first segment and behavior B for the remaining ones, and so I'd prefer to keep the code that does A and the code that does B distinct. It was a misguided attempt to share that code that got us into trouble here in the first place. Moreover, any future changes to either behavior will be that much harder if we combine the implementations. regards, tom lane
Commits
-
Apply a better fix to mdunlinkfork().
- 85d8b30724c0 16.0 landed
- 7b6610508d68 15.2 landed
-
Fix failure to remove non-first segments of temporary tables.
- 0e758ae89a20 16.0 cited
-
Use TRUNCATE to preserve relfilenode for pg_largeobject + index.
- 4ab5dae9472c 15.0 cited