On Thu, Mar 24, 2022 at 9:16 PM Andres Freund <and...@anarazel.de> wrote: > > VACUUM FREEZE (without DISABLE_PAGE_SKIPPING) seems like it would do > > everything you want, without using a temp table. At least on the > > master branch. > > We tried that in a prior case: > https://postgr.es/m/20220120052404.sonrhq3f3qgplpzj%40alap3.anarazel.de
Oh, yeah. If some other backend is holding back OldestXmin, and you can't find a way of dealing with that, then you'll need a temp table. (Mind you, that trick only works on recent versions too.) -- Peter Geoghegan