On Friday, May 1, 2020, Viral Shah <
viralshah009@gmail.com> wrote:
Now, this does explain why I need to increase the max_transaction_locks so that I can account for all the locks pg_locks is running into while pg_dump is in progress. I am still trying to understand why pg_get_statisticsobjdef() creates locks (AccessShare) on all the base tables at once leading to this issue?
You are dumping your entire database as a consistent point-in-time whole - how would that be doable without locking every data containing relation is the database?
David J.