Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lS2dV-0002ET-VL for pgsql-hackers@arkaria.postgresql.org; Thu, 01 Apr 2021 19:05:45 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lS2dU-0004G5-36 for pgsql-hackers@arkaria.postgresql.org; Thu, 01 Apr 2021 19:05:44 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lS2dT-0004FO-S9 for pgsql-hackers@lists.postgresql.org; Thu, 01 Apr 2021 19:05:43 +0000 Received: from out4-smtp.messagingengine.com ([66.111.4.28]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lS2dQ-0000Gj-JY for pgsql-hackers@lists.postgresql.org; Thu, 01 Apr 2021 19:05:42 +0000 Received: from compute2.internal (compute2.nyi.internal [10.202.2.42]) by mailout.nyi.internal (Postfix) with ESMTP id A3F205C00DC; Thu, 1 Apr 2021 15:05:38 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute2.internal (MEProxy); Thu, 01 Apr 2021 15:05:38 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-transfer-encoding:content-type :date:from:in-reply-to:message-id:mime-version:subject:to :x-me-proxy:x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s= fm2; bh=F4fVQFTNkWdOfcxtNaE98v3mNASzcEuf5C4AVNUKIXc=; b=pH/OkGGc xU2KLyKd9tIn8pXfMqgEbyrIkqrT41TLEbt3j1Aq/ec+PPHTa1KJ2bVYXAMRg5Qv QvuIlbY2+yXa9j2V5GhiWzJZ/uopxxJqOmv5ai4/00CnFUrN6rLGlVLomhyk8xlS VRZPOJrOHouP1Zp6w+btz+bZkGwGwhWL5QZXhyjXSB0clKxqXFmWPnckfUpFbBKe rUVTKYfdDFjegUHVQnbo2aN2VcqFtQKaZ3AFKW5RRp1w5tSksYt7hX7XILa8d5oz q4S5rX7hZfZRZzsl23jx5a61rjmARTslGp8fEMtFGSzqrdMeb8UR4IVtYVzehmrf eQLQwPtq5P+i8g== X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeduledrudeigedguddvgecutefuodetggdotefrod ftvfcurfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfgh necuuegrihhlohhuthemuceftddtnecuogetfedtledqtdduucdlvddtmdenucfjughrpe ffhffvuffkgggtugfgjggfsehtkeertddtredunecuhfhrohhmpedfkdgrlhhvhhgvrhhr vgesrghlvhhhrdhnohdqihhprdhorhhgkddfuceorghlvhhhvghrrhgvsegrlhhvhhdrnh hoqdhiphdrohhrgheqnecuggftrfgrthhtvghrnhepheekgeeivdeuffelhedtueffteej jedtteetueekuddvgeduiefhfeffvefftddunecukfhppeduledtrdelhedrudelrdelhe enucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepmhgrihhlfhhrohhmpegrlhhv hhgvrhhrvgesrghlvhhhrdhnohdqihhprdhorhhg X-ME-Proxy: Received: from perhan.alvh.no-ip.org (unknown [190.95.19.95]) by mail.messagingengine.com (Postfix) with ESMTPA id DCA6C24005E; Thu, 1 Apr 2021 15:05:37 -0400 (EDT) Received: by perhan.alvh.no-ip.org (Postfix, from userid 1000) id 457A92A032E; Thu, 1 Apr 2021 16:05:36 -0300 (-03) Date: Thu, 1 Apr 2021 16:05:36 -0300 From: "'alvherre@alvh.no-ip.org'" To: Tom Lane Cc: "iwata.aya@fujitsu.com" , "tsunakawa.takay@fujitsu.com" , 'Kyotaro Horiguchi' , "k.jamison@fujitsu.com" , "pgsql-hackers@lists.postgresql.org" Subject: Re: libpq debug log Message-ID: <20210401190536.GA29620@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <3455705.1617299197@sss.pgh.pa.us> User-Agent: Mutt/1.10.1 (2018-07-13) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 2021-Apr-01, Tom Lane wrote: > "'alvherre@alvh.no-ip.org'" writes: > > On 2021-Apr-01, Tom Lane wrote: > >> BTW, what in the world is this supposed to accomplish? > >> - (long long) rows_to_send); > >> + (1L << 62) + (long long) rows_to_send); > > > It makes the text representation wider, which means some buffer fills up > > faster and the program switches from sending to receiving. > > Hm. If the actual field value isn't relevant, why bother including > rows_to_send in it? A constant string would be simpler and much > less confusing as to its purpose. Hah, yeah, we could as well do that I guess :-) -- Álvaro Herrera Valdivia, Chile "I think my standards have lowered enough that now I think 'good design' is when the page doesn't irritate the living f*ck out of me." (JWZ)