Re: Init connection time grows quadratically - Mailing list pgsql-hackers

From shihao zhong
Subject Re: Init connection time grows quadratically
Date
Msg-id CAGRkXqQkYa6Onb0HAvFbJmpwokXug6=ECk2YByCeNmEsumZo4A@mail.gmail.com
Whole thread
In response to Re: Init connection time grows quadratically  (Потапов Александр <a.potapov@postgrespro.ru>)
Responses Re: Init connection time grows quadratically
List pgsql-hackers
Hi,

As CF manager, I moved this entry from Ready for Committer to Waiting on
Author.

> Maybe I am just missing something, but is this ever a benefit outside of
> completely arbitrary scenarios? 

On Andres's question, the closest workload I have seen is an AI app
behind pgbouncer. Some transactions stay open while they wait for an LLM
response, and background loading causes transactionid and tuple lock
waits. In spikes, pgbouncer grew to about 4000 server connections, then
shrank again.

The real problem there is locks and long transactions. This patch might help
the connection storm, but may not fix it.

In addition, CFBot now tests v6, not v5. Haibo, please post v6 separately.

Thanks,
Shihao

pgsql-hackers by date:

Previous
From: "Hayato Kuroda (Fujitsu)"
Date:
Subject: RE: pgoutput: schema cache cleanup after streamed 2PC
Next
From: Sami Imseih
Date:
Subject: Re: pg_xmin_horizon: a system view of everything pinning the xmin horizon