RE: CPU usage for queries, psycopg 2 vs 3

2023-09-07 Thread David Raymond
> Could you please be so kind as to repeat your tests with psycopg 3.1.4?
Tried with 3.1.4 and it has idle processor usage while waiting for the 8 
results, just like psycopg2.
Tried with 3.1.5 and it spikes up to 62% reported CPU usage while waiting for 
the 8 results, just like the current release.


> Also, did you try only to connect on localhost? Are you able to run the same 
> test with a server running on a different network location?
Have now tried with both a local host, and spreading the connections out over a 
number of remote servers, and the results are the same for both situations.




Re: CPU usage for queries, psycopg 2 vs 3

2023-09-07 Thread Daniele Varrazzo
On Thu, 7 Sept 2023 at 13:17, David Raymond  wrote:
>
> > Could you please be so kind as to repeat your tests with psycopg 3.1.4?
> Tried with 3.1.4 and it has idle processor usage while waiting for the 8 
> results, just like psycopg2.
> Tried with 3.1.5 and it spikes up to 62% reported CPU usage while waiting for 
> the 8 results, just like the current release.

Thank you, this gives a good indication about where to look.

-- Daniele