Re: CPU usage for queries, psycopg 2 vs 3 - Mailing list psycopg

From Daniele Varrazzo
Subject Re: CPU usage for queries, psycopg 2 vs 3
Date
Msg-id CA+mi_8Y1mF3w_J_ishB_SG_Tw3Wg=syQXWgOGZWfPrYaUL71Yg@mail.gmail.com
Whole thread Raw
In response to CPU usage for queries, psycopg 2 vs 3  (David Raymond <David.Raymond@tomtom.com>)
List psycopg
Hello David,

On Tue, 5 Sept 2023 at 18:52, David Raymond <David.Raymond@tomtom.com> wrote:
>
> I've noticed that CPU usage for queries seems to have drastically increased going from psycopg2 to psycopg3.
> [...]
> This is on Windows, where I install with "pip install psycopg2-binary" and "pip install psycopg[binary]"

I have tested your script on Linux and on this platform I can't
reproduce the issue. Psycopg 3 CPU usage remains low.

I will try to repeat your test on Windows.

-- Daniele



psycopg by date:

Previous
From: Daniele Varrazzo
Date:
Subject: Re: CPU usage for queries, psycopg 2 vs 3
Next
From: Daniele Varrazzo
Date:
Subject: Re: CPU usage for queries, psycopg 2 vs 3