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

From Потапов Александр
Subject Re: Init connection time grows quadratically
Date
Msg-id 3b7e5e-684fdc80-f-48e15c80@193664207
Whole thread Raw
In response to Re: Init connection time grows quadratically  (Потапов Александр <a.potapov@postgrespro.ru>)
List pgsql-hackers

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 thread creation or connection establishment, e.g. by varying
> the number of threads used to manage these N clients? I wouldn't be
> surprised if there are inefficiencies in e.g. the threading- or
> synchronization model that cause O(N) per-thread overhead, or O(N^2)
> overall when you have one thread per connection.

 

Attachment

pgsql-hackers by date:

Previous
From: Evgeniy Gorbanev
Date:
Subject: Re: No error checking when reading from file using zstd in pg_dump
Next
From: Daniel Gustafsson
Date:
Subject: Re: No error checking when reading from file using zstd in pg_dump