Re: PostgreSql: Canceled on conflict out to old pivot

2023-11-27 Thread Ron Johnson
On Mon, Nov 27, 2023 at 2:17 AM Wirch, Eduard wrote: > Hi > > We have a PostgreSql 15 server serving around 30 databases, one schema > each with the same layout. Each database is used by one application > instance. The application consistently uses transactions with isolation > level serializable

PostgreSql: Canceled on conflict out to old pivot

2023-11-26 Thread Wirch, Eduard
Hi We have a PostgreSql 15 server serving around 30 databases, one schema each with the same layout. Each database is used by one application instance. The application consistently uses transactions with isolation level serializable to access the database, optimizing by using explicit read only tr