public inbox for [email protected]
help / color / mirror / Atom feedFrom: David Raymond <[email protected]>
To: Daniele Varrazzo <[email protected]>
Cc: [email protected] <[email protected]>
Subject: RE: CPU usage for queries, psycopg 2 vs 3
Date: Thu, 7 Sep 2023 12:17:40 +0000
Message-ID: <DB7PR07MB39169ECBC7E0E02E8315982F87EEA@DB7PR07MB3916.eurprd07.prod.outlook.com> (raw)
In-Reply-To: <CA+mi_8Z98u3Gq-3JrAbWRW7ar9hhPAO5umze==xgpEHdxdcPKQ@mail.gmail.com>
References: <DB7PR07MB3916A230837909499A87EF3287E8A@DB7PR07MB3916.eurprd07.prod.outlook.com>
<CA+mi_8Z98u3Gq-3JrAbWRW7ar9hhPAO5umze==xgpEHdxdcPKQ@mail.gmail.com>
> 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.
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: <DB7PR07MB39169ECBC7E0E02E8315982F87EEA@DB7PR07MB3916.eurprd07.prod.outlook.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