On Monday, December 13, 2021, Marc Millas <marc.mil...@mokadb.com> wrote: > > I was wondering if for example, within a join, some kind of lock may be > acquired so that the dataset concerned is not changed during execution ? > (for example a delete then autovacuum ??) >
Read this primer on MVCC from the docs: https://www.postgresql.org/docs/current/mvcc-intro.html David J.