On Tue, Nov 24, 2020 at 10:33:46AM -0500, David Gauthier wrote: > Ok, thanks. > > I was also planning on manually running vacuum, reindex and analyze on the main > DB after removing the data from the main DB after archiving. Does that sound > necessary and reasonable ? This blog entry summarizes the various levels of isolation and their benefits: https://momjian.us/main/blogs/pgblog/2012.html#April_23_2012 -- Bruce Momjian <bruce@xxxxxxxxxx> https://momjian.us EnterpriseDB https://enterprisedb.com The usefulness of a cup is in its emptiness, Bruce Lee