Re: huge SubtransSLRU and SubtransBuffer wait_event

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: huge SubtransSLRU and SubtransBuffer wait_event
Дата
Msg-id 202402020812.6yy7rpe2xfhb@alvherre.pgsql
обсуждение исходный текст
Ответ на RE: huge SubtransSLRU and SubtransBuffer wait_event  ("James Pang (chaolpan)" <chaolpan@cisco.com>)
Список pgsql-performance
On 2024-Feb-02, James Pang (chaolpan) wrote:

>   Possible to increase  Subtrans SLRU buffer size ?

Not at present -- you need to recompile after changing
NUM_SUBTRANS_BUFFERS in src/include/access/subtrans.h,
NUM_MULTIXACTOFFSET_BUFFERS and NUM_MULTIXACTMEMBER_BUFFERS in
src/include/access/multixact.h.

There's pending work to let these be configurable in version 17.

>   Our case is   1) we use PL/PGSQL procedure1-->procedure2 (update
>   table xxxx;commit);   2) application JDBC client call procedure1
>   (it's a long running job, sometimes it could last > 1hours).
>   During this time window,  other Postgresql JDBC clients (100-200)
>   coming in in same time , then quickly see MultiXactoffset and
>   SubtransSLRU increased very quickly. 
>   PL/PGSQL proc1--> procedure2(updates table) it use substransation in
>   procedure2 ,right? 

If your functions/procedures use EXCEPTION clauses, that would create
subtransactions also.

-- 
Álvaro Herrera        Breisgau, Deutschland  —  https://www.EnterpriseDB.com/
"No deja de ser humillante para una persona de ingenio saber
que no hay tonto que no le pueda enseñar algo." (Jean B. Say)



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

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