In a handful of Baserow features, such as snapshotting and duplicating, we take the specified database and fetch all of its tables to perform operations on them.
Unfortunately if the total number of tables in the database is very high (i.e. 5,000-10,000), it’s possible to exceed
the total number of locks specified in PostgreSQL’s
To resolve this, the steps are as follows:
psqlthis can be found with
max_prepared_transactionsare set to. We recommend experimenting with higher values.
If you are hosting Baserow with a managed database, please ask your hosting provider how
can be increased, they may be able to increase it for you.