Re: huge SubtransSLRU and SubtransBuffer wait_event

Поиск
Список
Период
Сортировка
От Laurenz Albe
Тема Re: huge SubtransSLRU and SubtransBuffer wait_event
Дата
Msg-id 2e9c28409b28546235c68e6440e6f9e9cf4be995.camel@cybertec.at
обсуждение исходный текст
Ответ на huge SubtransSLRU and SubtransBuffer wait_event  ("James Pang (chaolpan)" <chaolpan@cisco.com>)
Ответы RE: huge SubtransSLRU and SubtransBuffer wait_event  ("James Pang (chaolpan)" <chaolpan@cisco.com>)
Re: huge SubtransSLRU and SubtransBuffer wait_event  (Nikolay Samokhvalov <samokhvalov@gmail.com>)
Список pgsql-performance
Дерево обсуждения 
On Thu, 2024-02-01 at 11:50 +0000, James Pang (chaolpan) wrote:
> We have a Postgresqlv14.8 server, client use Postgresql JDBC connections, today,
> our server see a lot of  “SubtransBuffer” and “SubtransSLRU” wait_event.
> Could you help direct me what’s the possible cause and how to resolve this waits ?

Today, the only feasible solution is not to create more than 64 subtransactions
(savepoints or PL/pgSQL EXCEPTION clauses) per transaction.

Don't use extensions or the JDBC driver option to simulate statement level rollback,
that is the road to hell.

Yours,
Laurenz Albe

В списке pgsql-performance по дате отправления:

Предыдущее
От: "James Pang (chaolpan)"
Дата:
Сообщение: huge SubtransSLRU and SubtransBuffer wait_event
Следующее
От: Daniel Blanch Bataller
Дата:
Сообщение: Memory growth using many named prepared statements, in spite of using DISCARD ALL afterwards.