Hi Alvaro ,
looks like Xact slru buffer use a different way to control size, do we
need to increase Xact and how to increase that ? we plan to increase to
20 times size of existing buffers, any side impact to 20 times increase
these subtrans ?
+-+-+-
On 2024-Mar-01, James Pang wrote:
> one question:
> we need to increase all SLRU buffers together , MULTIXACT, XACT,
> Subtrans, COMMIT TS , for example, got all of them doubled based on
> existing size ?
No need.
> or only increase Subtrans , or Subtrans and multixact ?
Just increase the
-
> From: Alvaro Herrera
> Sent: Friday, February 2, 2024 4:13 PM
> To: James Pang (chaolpan)
> Cc: Laurenz Albe ;
> pgsql-performance@lists.postgresql.org
> Subject: Re: huge SubtransSLRU and SubtransBuffer wait_event
>
> On 2024-Feb-02, James Pang (chaolpan) wrote:
>
&g
)
> *Sent:* Tuesday, February 6, 2024 2:59 PM
> *To:* Nikolay Samokhvalov ; Laurenz Albe <
> laurenz.a...@cybertec.at>; pgsql-performance@lists.postgresql.org
> *Subject:* RE: huge SubtransSLRU and SubtransBuffer wait_event
>
>
>
>We finally identified the caus
parallel
sessions count doing same query at the same time help a lot.
Thanks all.
James
From: Nikolay Samokhvalov
Sent: Friday, February 2, 2024 6:04 PM
To: Laurenz Albe ;
pgsql-performance@lists.postgresql.org
Subject: Re: huge SubtransSLRU and SubtransBuffer wait_event
On Thu, Feb 1
On Fri, 2024-02-02 at 02:04 -0800, Nikolay Samokhvalov wrote:
> On Thu, Feb 1, 2024 at 04:42 Laurenz Albe wrote:
> > Today, the only feasible solution is not to create more than 64
> > subtransactions
> > (savepoints or PL/pgSQL EXCEPTION clauses) per transaction.
>
> I think 64+ nesting level i
On Thu, Feb 1, 2024 at 04:42 Laurenz Albe wrote:
> Today, the only feasible solution is not to create more than 64
> subtransactions
> (savepoints or PL/pgSQL EXCEPTION clauses) per transaction.
Sometimes, a single subtransaction is enough to experience a bad
SubtransSLRU spike:
https://postgre
>From: James Pang (chaolpan) Sent: Friday, February 2, 2024
>7:47 AMTo: Laurenz Albe ;
>pgsql-performance@lists.postgresql.org
>Subject: RE: huge SubtransSLRU and
>SubtransBuffer wait_event
>
> Our case is 1) we use PL/PGSQL procedure1-->procedure2 (update ta
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/multix
Sent: Thursday, February 1, 2024 11:34 PM
To: Laurenz Albe ;
pgsql-performance@lists.postgresql.org
Subject: RE: huge SubtransSLRU and SubtransBuffer wait_event
Today, the only feasible solution is not to create more than 64 subtransactions
(savepoints or PL/pgSQL EXCEPTION clauses) per transacti
l.org
Subject: Re: huge SubtransSLRU and SubtransBuffer wait_event
On Thu, 2024-02-01 at 11:50 +, 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_even
On Thu, 2024-02-01 at 11:50 +, 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 th
Hi,
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 ?
Thanks,
James
13 matches
Mail list logo
