Re: Cleaning up nbtree after logical decoding on standby work
Andres Freund <andres@anarazel.de>
From: Andres Freund <andres@anarazel.de>
To: Peter Geoghegan <pg@bowt.ie>
Cc: Alvaro Herrera <alvherre@alvh.no-ip.org>, Heikki Linnakangas <hlinnaka@iki.fi>, Michael Paquier <michael@paquier.xyz>, PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>, "Drouvot, Bertrand" <bertranddrouvot.pg@gmail.com>
Date: 2023-06-10T04:40:15Z
Lists: pgsql-hackers
Hi, On 2023-06-09 12:23:36 -0700, Peter Geoghegan wrote: > On Fri, Jun 9, 2023 at 12:03 PM Andres Freund <andres@anarazel.de> wrote: > > > My new plan is to commit this tomorrow, since the clear consensus is > > > that we should go ahead with this for 16. > > > > I'm not sure there is that concensus (for me half the changes shouldn't be > > done, the rest should be in 17), but in the end it doesn't matter that much. > > Really? What parts are you opposed to in principle? I don't see why > you wouldn't support everything or nothing for 17 (questions of style > aside). I don't see what's ambiguous about what we should do here, > barring the 16-or-17 question. I don't think minimizing heaprel being passed around is a worthwhile goal, the contrary actually: It just makes it painful to use heaprel anywhere, because it causes precisely these cascading changes of adding/removing the parameter to a bunch of functions. If anything we should do the opposite. > It's not like nbtree ever really "used P_NEW". It doesn't actually > depend on any of the P_NEW handling inside bufmgr.c. It looks a little > like it might, but that's just an accident. That part I am entirely on board with, as mentioned earlier. It doesn't seem like 16 material though. Greetings, Andres Freund
Commits
-
nbtree: Allocate new pages in separate function.
- d088ba5a5aa4 16.0 landed
-
Pass down table relation into more index relation functions
- 61b313e47eb9 16.0 cited
-
Note case where nbtree VACUUM finishes splits.
- 35bc0ec7c800 12.0 cited
-
Fix interaction between CREATE INDEX and "snapshot too old".
- bf9a60ee3349 9.6.0 cited