PostgreSql: Canceled on conflict out to old pivot

2023-11-27 Thread Wirch, Eduard
Hi I posted this question already on pgsql-general, but it got no answers. Maybe the topic is too technical? So I'm trying it here. Maybe a SSI specialist is here on the list. We have a PostgreSql 15 server serving around 30 databases, one schema each with the same layout. Each database is used b

Re: PostgreSql: Canceled on conflict out to old pivot

2023-11-30 Thread Wirch, Eduard
/questions/77544821/postgresql-canceled-on-conflict-out-to-old-pivot Cheers, Eduard Am Di., 28. Nov. 2023 um 09:53 Uhr schrieb Heikki Linnakangas < hlinn...@iki.fi>: > On 28/11/2023 07:41, Wirch, Eduard wrote: > > ERROR: could not serialize access due to read/write dependencies am

Re: PostgreSql: Canceled on conflict out to old pivot

2023-12-01 Thread Wirch, Eduard
Thanks guys for the valuable info. The key take away for me is clear: keep transactions short under all circumstances. Cheers, Eduard Am Fr., 1. Dez. 2023 um 01:31 Uhr schrieb Andres Freund : > Hi, > > On 2023-11-30 18:51:35 -0500, Tom Lane wrote: > > On what grounds do you assert that? Operati