Re: PostgreSql: Canceled on conflict out to old pivot - Mailing list pgsql-general

From Ron Johnson
Subject Re: PostgreSql: Canceled on conflict out to old pivot
Date
Msg-id CANzqJaDES0Am_F-NJb_3UPpMpYE6wA-Tz-fuO0Bzw4U8ndTjzw@mail.gmail.com
Whole thread Raw
In response to PostgreSql: Canceled on conflict out to old pivot  ("Wirch, Eduard" <eduard.w@smart-host.com>)
List pgsql-general
On Mon, Nov 27, 2023 at 2:17 AM Wirch, Eduard <eduard.w@smart-host.com> 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 to access the database, optimizing by using explicit read only transactions, where applicable. Once the server reaches 100% we get an increased amount of serialize conflict errors.
 
Maybe I haven't had my coffee yet, but 100% of what?

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Emitting JSON to file using COPY TO
Next
From: Dominique Devienne
Date:
Subject: Re: Emitting JSON to file using COPY TO