Re: PostgreSql: Canceled on conflict out to old pivot

Поиск
Список
Период
Сортировка
От Ron Johnson
Тема Re: PostgreSql: Canceled on conflict out to old pivot
Дата
Msg-id CANzqJaDES0Am_F-NJb_3UPpMpYE6wA-Tz-fuO0Bzw4U8ndTjzw@mail.gmail.com
обсуждение исходный текст
Ответ на PostgreSql: Canceled on conflict out to old pivot  ("Wirch, Eduard" <eduard.w@smart-host.com>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Emitting JSON to file using COPY TO
Следующее
От: Dominique Devienne
Дата:
Сообщение: Re: Emitting JSON to file using COPY TO