public inbox for [email protected]  

help / color / mirror / Atom feed

From: Daniele Varrazzo <[email protected]>
To: David Raymond <[email protected]>
Cc: [email protected] <[email protected]>
Subject: Re: CPU usage for queries, psycopg 2 vs 3
Date: Tue, 19 Sep 2023 22:44:20 +0200
Message-ID: <CA+mi_8Z0JkU0pu=dax5o3Hs0JUKf+9QOWbp3LsMJXLUk0Ke4Gw@mail.gmail.com> (raw)
In-Reply-To: <DB7PR07MB39169ECBC7E0E02E8315982F87EEA@DB7PR07MB3916.eurprd07.prod.outlook.com>
References: <DB7PR07MB3916A230837909499A87EF3287E8A@DB7PR07MB3916.eurprd07.prod.outlook.com>
	<CA+mi_8Z98u3Gq-3JrAbWRW7ar9hhPAO5umze==xgpEHdxdcPKQ@mail.gmail.com>
	<DB7PR07MB39169ECBC7E0E02E8315982F87EEA@DB7PR07MB3916.eurprd07.prod.outlook.com>

Hello David,

On Thu, 7 Sept 2023 at 14:17, David Raymond <[email protected]> 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.

I am not able to quickly investigate this issue, because I don't have
a Windows machine handy. However I would like to release 3.1.11 soon,
so I would like to merge this changeset, which should revert the wait
function to what was in 3.1.4 on Windows:

https://github.com/psycopg/psycopg/commit/36f70532c4451d04c0052c6eac4d05380159e809

Are you able to test it to verify that CPU usage is regular with this changeset?

Also please note that you sent your last, very informative, message,
to me only: maybe you want to send it to the ML?

If someone is able to look into this issue better, it would be some
welcome help. FYI, I've reported it at
https://github.com/psycopg/psycopg/issues/645

Cheers

-- Daniele

view thread (9+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: CPU usage for queries, psycopg 2 vs 3
  In-Reply-To: <CA+mi_8Z0JkU0pu=dax5o3Hs0JUKf+9QOWbp3LsMJXLUk0Ke4Gw@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox