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 ) id 1qfuVJ-00DZXK-5f for pgsql-hackers@arkaria.postgresql.org; Tue, 12 Sep 2023 03:55:57 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qfuVH-004txU-J6 for pgsql-hackers@arkaria.postgresql.org; Tue, 12 Sep 2023 03:55:55 +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 ) id 1qfuVH-004tx6-88 for pgsql-hackers@lists.postgresql.org; Tue, 12 Sep 2023 03:55:55 +0000 Received: from out5-smtp.messagingengine.com ([66.111.4.29]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qfuVD-0044mz-RZ for pgsql-hackers@postgresql.org; Tue, 12 Sep 2023 03:55:53 +0000 Received: from compute1.internal (compute1.nyi.internal [10.202.2.41]) by mailout.nyi.internal (Postfix) with ESMTP id 42C435C0154; Mon, 11 Sep 2023 23:55:51 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute1.internal (MEProxy); Mon, 11 Sep 2023 23:55:51 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= cc:cc:content-type:content-type:date:date:from:from:in-reply-to :in-reply-to:message-id:mime-version:references:reply-to:sender :subject:subject:to:to; s=fm1; t=1694490951; x=1694577351; bh=vh I2iC3Fck1NNiZEMGxKzqhqMb9bYzTZXJ/XiDF5NTk=; b=jgqpGvyrvbuJdGR7Lt F9IVA7n3J3s2FlHKdZfftkkxImLcCu1YsdVsIcXRXOPkAHjnnTycWE6mgLblbhIl aIqGj/LrF2GG6QlMtDqxe/mKU/DQ4PAc/R1qo06/tuYeKzoxNnXhX/hOiYJwvF8f N8V+dwB9AOQk7cXPlD5gLeBfqzUmpjldB0cVQXwvm4T0Ze2oqVH0Ywti03/J3Dxo U5Aryfy6snFhO64q8UfLcZMgJrjItf5sqIwBlmfawGSsog1qmzRAAvgaAOCKK1Ds B/n9/rT/EK9Vb06sjwSXXjxB+gfPOjFoR4aWOQ+CJShWR6dWlapC2VkndDjbMHcN whiA== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-type:content-type:date:date :feedback-id:feedback-id:from:from:in-reply-to:in-reply-to :message-id:mime-version:references:reply-to:sender:subject :subject:to:to:x-me-proxy:x-me-proxy:x-me-sender:x-me-sender :x-sasl-enc; s=fm1; t=1694490951; x=1694577351; bh=vhI2iC3Fck1NN iZEMGxKzqhqMb9bYzTZXJ/XiDF5NTk=; b=cCeKEg/U49gYuFrXsnxg5wd6cQdf1 7lvkjMeBc31UtotfSnBqdmA884+PegGvU6qjg0sakiDYNAs3GzqnnUSZ0dcl8aoQ b0lLtWk22Z331CzqgVIc4MekcG5zINySumWnhqtbiCdRWFHkygz5f7mgeDC3ZYcp PbGhKC1hjul0e47h8L2rml5SDW1Crw3iJ5wJFTjF3gmbl+HrRS2Nnupjp+jWIamU kuWfIe/2XFWiTxHTHbDVqjZkE0ujAzgGVouEzGEQmkoZSsxbdb2hqU2ntvESvedR eVtE4gYyn9yJ6fva/eSygs4QTfEAxCiQ6x3x39CCYZaU6eHvQx5zGoLJA== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedviedrudeihedgjeehucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne gfrhhlucfvnfffucdlfeehmdenucfjughrpeffhffvvefukfhfgggtuggjsehgtderredt tddvnecuhfhrohhmpefoihgthhgrvghlucfrrghquhhivghruceomhhitghhrggvlhesph grqhhuihgvrhdrgiihiieqnecuggftrfgrthhtvghrnhepgeffjeevgfevuddvjedtvddt ieejheduueelvddufedtgfefjedvkeevkeeivddvnecuffhomhgrihhnpehpohhsthhgrh gvshhqlhdrohhrghenucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepmhgrihhl fhhrohhmpehmihgthhgrvghlsehprghquhhivghrrdighiii X-ME-Proxy: Feedback-ID: i0fe9450f:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Mon, 11 Sep 2023 23:55:48 -0400 (EDT) Date: Tue, 12 Sep 2023 12:55:44 +0900 From: Michael Paquier To: Hongxu Ma Cc: Jelte Fennema , "David G. Johnston" , PostgreSQL Hackers Subject: Re: PSQL error: total cell count of XXX exceeded Message-ID: References: MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="saAlqufoWHHjk2Jo" Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --saAlqufoWHHjk2Jo Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Tue, Sep 12, 2023 at 02:39:55AM +0000, Hongxu Ma wrote: > Thank you for your advice, Jelte. > I have refactored my code, please see the attached patch. (and I put > it into https://commitfest.postgresql.org/45/ for trace) { + long total_cells; long is 4 bytes on Windows, and 8 bytes basically elsewhere. So you would still have the same problem on Windows, no? -- Michael --saAlqufoWHHjk2Jo Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmT/4UAACgkQnvQgOdby QH3SIhAAlBktNbTm8NpmRJ/3yggpqtxHLi470pr6xaqrbZleC/h+PvFpzla6Hr7Y SiaqDS1RLKJCw+oICHuYNvZYTDis2Ah4yeAvByhn32lNTrbSuB8nSkSGEnzw3Dic LiToEbGMdoA/0bzRWDxqft4oArPdoZ4AYCRDYJ7DcpgTwl/su/pqmFR8/H9kmy0L a3LSksFq5p6NuBgs9I8qkmacV4YKfDFK1Gu2wYMk4EGUidc3CqeaSZmdRdgqlJZh di35nmkKpk4ygl4GrpvA2coOPtdmLAbX7Tqk7WKhNsdZt/t5/y5X7g6CYM2ZmBvx Va+vA2aITcvK9uXgBillwYy1msqMzUmPyh2d52uuT1FzL1DEHn6+Fby32k91KSjR PaWzeqCsONIGLK1IAkxVnbarGqTUHOjxgRNSNGkKKnW2XOut253iNudDLdgBAQdM p6in+fhmJ4f0hYXgnMlXYC04YSFJela1fwz0TuvnUnci5ljlBaC3NKgW4UThNu2T p951RPKPL+IzE2eMUUfKUTh02jQ/xCxmE6Qw2mYN3UdW53LGP7O2dsaqReFImbot xwlBfaZPyc49tq98eA1UAG9GNMJQkX/BmmLUgCSJmiwEkWDBCItrwIk+GN2+r3s5 Ty8GTJhLYYr58OUOJajCPFaXNxkhQbCr6LgDZQNQwmlP8c2hZG0= =M5VE -----END PGP SIGNATURE----- --saAlqufoWHHjk2Jo--