At Tue, 15 Jun 2021 22:07:32 +0800, Julien Rouhaud <rjuju...@gmail.com> wrote in > On Tue, Jun 15, 2021 at 9:31 PM Andrew Dunstan <and...@dunslane.net> wrote: > > > > Rather than use size, I'd be inclined to say use this if the source > > database is marked as a template, and use the copydir approach for > > anything that isn't. > > Looks like a good approach.
If we are willing to maintain the two methods. Couldn't we just skip the checkpoints if the database is known to "clean", which means no page has been loaded for the database since startup? We can use the "template" mark to reject connections to the database. (I'm afraid that we also should prevent vacuum to visit the template databases, but...) regards. -- Kyotaro Horiguchi NTT Open Source Software Center
