Re: CPU usage for queries, psycopg 2 vs 3

From: Daniele Varrazzo <daniele(dot)varrazzo(at)gmail(dot)com>
To: David Raymond <David(dot)Raymond(at)tomtom(dot)com>
Cc: "psycopg(at)postgresql(dot)org" <psycopg(at)postgresql(dot)org>
Subject: Re: CPU usage for queries, psycopg 2 vs 3
Date: 2023-09-11 15:26:21
Message-ID: CA+mi_8Y1mF3w_J_ishB_SG_Tw3Wg=syQXWgOGZWfPrYaUL71Yg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: psycopg

Hello David,

On Tue, 5 Sept 2023 at 18:52, David Raymond <David(dot)Raymond(at)tomtom(dot)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

In response to

Browse psycopg by date

  From Date Subject
Next Message Daniele Varrazzo 2023-09-19 20:44:20 Re: CPU usage for queries, psycopg 2 vs 3
Previous Message Daniele Varrazzo 2023-09-07 12:43:58 Re: CPU usage for queries, psycopg 2 vs 3