Re: Init connection time grows quadratically

2025-06-16 Thread Потапов Александр
To be more precise I used constant number of threads (128 and 1024) to compare with previous results. The quadratic dependency exists everywhere, see new graph. > Q: Did you check that pgbench or the OS does not have > O(n_active_connections) or O(n_active_threads) overhead per worker > during

Re: Init connection time grows quadratically

2025-06-10 Thread Потапов Александр
Hi Matthias,   I did additional experiments (changed a number of threads on pgbench side an on server side) but it did find not chanches.   Вторник, Май 27, 2025 14:36 MSK, Matthias van de Meent писал(а):   On Tue, 27 May 2025 at 12:45, Потапов Александр wrote: > > Hello! > > I ran some exp

Re: Init connection time grows quadratically

2025-05-27 Thread Matthias van de Meent
On Tue, 27 May 2025 at 12:45, Потапов Александр wrote: > > Hello! > > I ran some experiments with pgbench to measure the initialization time and > found that the time increases quadratically with the number of clients. It > was surprising to me and I would like to understand a reason of such beh

Re: Init connection time grows quadratically

2025-05-27 Thread Потапов Александр
Sorry, I forgot to add the table and graph for point #8 The graph is attached.  This is the table: -- | Number of clients  |  Average init time, ms | -- |            1024             |        ~435 +-20

Init connection time grows quadratically

2025-05-27 Thread Потапов Александр
Hello!   I ran some experiments with pgbench to measure the initialization time and found that the time increases quadratically with the number of clients. It was surprising to me and I would like to understand a reason of such behavior.   Some details on how it was done:   1) I used the branch