Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <psycopg-owner+archive@lists.postgresql.org>)
	id 1qjFzK-00A0uu-GG
	for psycopg@arkaria.postgresql.org; Thu, 21 Sep 2023 09:28:46 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <psycopg-owner+archive@lists.postgresql.org>)
	id 1qjFzH-00ABjH-QF
	for psycopg@arkaria.postgresql.org; Thu, 21 Sep 2023 09:28:43 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <daniele.varrazzo@gmail.com>)
	id 1qjFzH-00ABj2-Ig
	for psycopg@lists.postgresql.org; Thu, 21 Sep 2023 09:28:43 +0000
Received: from mail-oa1-x31.google.com ([2001:4860:4864:20::31])
	by makus.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256
	(Exim 4.94.2)
	(envelope-from <daniele.varrazzo@gmail.com>)
	id 1qjFzF-005mco-4A
	for psycopg@postgresql.org; Thu, 21 Sep 2023 09:28:42 +0000
Received: by mail-oa1-x31.google.com with SMTP id
 586e51a60fabf-1dc90f2adb9so67050fac.1
        for <psycopg@postgresql.org>; Thu, 21 Sep 2023 02:28:40 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20230601; t=1695288520; x=1695893320;
 darn=postgresql.org;
        h=cc:to:subject:message-id:date:from:in-reply-to:references
         :mime-version:from:to:cc:subject:date:message-id:reply-to;
        bh=K1VYOf/UD2RSrpEeQHyEL75CF87JIW2+1qXekQ3GMD8=;
        b=WtgUtR4XS2NWzs+SklB7Q2wuGnRH4Otu5o2rBtQDbBvI0xMn4lHkokwNyNyqaeDtvb
         LP+ISC8dcXw1mUrxg03J2uu2C0ghCsHBoFx0UVjzMblopejDadl9/bDJCwgiKo0rDq+L
         zSssIqZ+ofNYzQM8Rhz24GZJ5ISsDwEtqNU+CQnee4E11hxjf2eYXcL0ivG3CWnZdUX6
         N7xySURM/DXD0e+u7DLo+mYk4yAjKXy59880ydlYPVOoLR2xqB4pkOIPbgXuriIjHrzi
         XMq/mTYL6M9RZCNlyeYA5ATjmFKu56SjLl92JAgNuTZetshFxlgndZqHsmtQ+NLVmAbK
         ygPQ==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20230601; t=1695288520; x=1695893320;
        h=cc:to:subject:message-id:date:from:in-reply-to:references
         :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id
         :reply-to;
        bh=K1VYOf/UD2RSrpEeQHyEL75CF87JIW2+1qXekQ3GMD8=;
        b=dgmdnsQEdfJW+HY9SWTIz6eWLtBCjO0r2eXRSs+ZthRWX928lQASuI01JnxRx9iGK/
         yXvPIZn6nLJmA3H8TJwRK6qUhhzYP4ghwYkbr0bf+ZE8Ilk4vSX0jFtukskUlfN8THNd
         5RkmLlUPeysJcWOViAL5CALgZ4pSQNjf6sH4AyVeKaO1qrAj/q+8rHgHnjH8uDM7dv1j
         p45uTA6ssyPdGeJYSx6IQOqN6RAgMM3WPT07Li6mRCltNJCjCwApjSUBUkn06Qp249l0
         yD7vk0XilBkaXXDR4ITDLzIopwWxnCOn0OsCNVJh3xNd2igFvt6ULGdVatQau2TLwFhs
         Qsjg==
X-Gm-Message-State: AOJu0YwpXRHxVFuuyKjE2qOfMphoX9SxGwjPvIud4iimSt11umBQqd0Z
	bnALKKDs2JB0l6UBKOnTls3hrTae+/uYsPG6h9g=
X-Google-Smtp-Source: 
 AGHT+IGXuLAUEXzRnPv46Z0dmu3HpKaBOPc5MNGjBk9znNL64ZTkOBXT3iiUDcRcxR96n9bDqDA9VkuFl9Rh/NCtuEQ=
X-Received: by 2002:a05:6870:96a4:b0:1b0:454b:1c3d with SMTP id
 o36-20020a05687096a400b001b0454b1c3dmr5145967oaq.36.1695288520352; Thu, 21
 Sep 2023 02:28:40 -0700 (PDT)
MIME-Version: 1.0
References: 
 <DB7PR07MB3916A230837909499A87EF3287E8A@DB7PR07MB3916.eurprd07.prod.outlook.com>
 <CA+mi_8Z98u3Gq-3JrAbWRW7ar9hhPAO5umze==xgpEHdxdcPKQ@mail.gmail.com>
 <DB7PR07MB39169ECBC7E0E02E8315982F87EEA@DB7PR07MB3916.eurprd07.prod.outlook.com>
 <CA+mi_8Z0JkU0pu=dax5o3Hs0JUKf+9QOWbp3LsMJXLUk0Ke4Gw@mail.gmail.com>
 <DB7PR07MB391650DB3D30B796DE2F81F687F9A@DB7PR07MB3916.eurprd07.prod.outlook.com>
In-Reply-To: 
 <DB7PR07MB391650DB3D30B796DE2F81F687F9A@DB7PR07MB3916.eurprd07.prod.outlook.com>
From: Daniele Varrazzo <daniele.varrazzo@gmail.com>
Date: Thu, 21 Sep 2023 11:28:28 +0200
Message-ID: 
 <CA+mi_8YQS8wa3BzgDxbQEG1+-J4xaqZRQo4fxvCxUQPMXM1OEw@mail.gmail.com>
Subject: Re: CPU usage for queries, psycopg 2 vs 3
To: David Raymond <David.Raymond@tomtom.com>
Cc: "psycopg@postgresql.org" <psycopg@postgresql.org>
Content-Type: text/plain; charset="UTF-8"
List-Id: <psycopg.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:psycopg@lists.postgresql.org>
List-Owner: <mailto:psycopg-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/psycopg>
Archived-At: 
 <https://www.postgresql.org/message-id/CA%2Bmi_8YQS8wa3BzgDxbQEG1%2B-J4xaqZRQo4fxvCxUQPMXM1OEw%40mail.gmail.com>
Precedence: bulk

On Wed, 20 Sept 2023 at 16:27, David Raymond <David.Raymond@tomtom.com> wrote:
>
> Looks good. With the change it quietly idles while waiting for query results, with no CPU spike.

Thank you for confirming. I will release Psycopg 3.1.11 in the next
few days, with this changeset included.

Cheers

-- Daniele