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 1tkrJw-007Pmg-Cz for pgsql-hackers@arkaria.postgresql.org; Wed, 19 Feb 2025 21:09:28 +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 1tkrJu-00DebO-CM for pgsql-hackers@arkaria.postgresql.org; Wed, 19 Feb 2025 21:09:26 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tkrJt-00DebF-I8 for pgsql-hackers@lists.postgresql.org; Wed, 19 Feb 2025 21:09:26 +0000 Received: from fout-a7-smtp.messagingengine.com ([103.168.172.150]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1tkrJq-001pj5-1J for pgsql-hackers@lists.postgresql.org; Wed, 19 Feb 2025 21:09:25 +0000 Received: from phl-compute-04.internal (phl-compute-04.phl.internal [10.202.2.44]) by mailfout.phl.internal (Postfix) with ESMTP id 4A066138099B; Wed, 19 Feb 2025 16:09:19 -0500 (EST) Received: from phl-mailfrontend-01 ([10.202.2.162]) by phl-compute-04.internal (MEProxy); Wed, 19 Feb 2025 16:09:19 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-transfer-encoding :content-type:content-type:date:date:feedback-id:feedback-id :from:from:in-reply-to:in-reply-to:message-id:mime-version :reply-to:subject:subject:to:to:x-me-proxy:x-me-sender :x-me-sender:x-sasl-enc; s=fm3; t=1739999359; x=1740085759; bh=b BtaCMch1Vt1nVTJ+3wlv+B+lR6VWXm9ms2hUy4kYbk=; b=s2797GKXepIWTxGxe hOFNchQ+2hcfnUOF3MFbY40ED6zL+BLZbx0+Aw+5+eeMEEEBVyqvGJIpLHNWfFrN sve8UTAKEaOnI94ky/MB/+U/netXp834FIA5ZQ3ElwRl4eRgLh9aF7Jls/ZywPAf PbsRwkG8VBpfF0PpDCCoyQzGh/MhOPlWdy6L00GUlqX0cw0jjxOrQUUp340thb2e 9E4mfwiDrdMbYe2dIurs0MReQ3kRuX/FrX/PvT0+E6NhSLPqUmhOY6ptdn/atJML hjsYvEx2nhMFk86SLC8dQ7jDM1d71MBnDVDQ2kE1bmsgHR4CTdGPMJyFkqz3YQpw Acrqg== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeefvddrtddtgdeiheefudcutefuodetggdotefrod ftvfcurfhrohhfihhlvgemucfhrghsthforghilhdpggftfghnshhusghstghrihgsvgdp uffrtefokffrpgfnqfghnecuuegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivg hnthhsucdlqddutddtmdenucfjughrpeffhffvvefukfggtggugfgjsehtkeertddttdej necuhfhrohhmpemllhhvrghrohcujfgvrhhrvghrrgcuoegrlhhvhhgvrhhrvgesrghlvh hhrdhnohdqihhprdhorhhgqeenucggtffrrghtthgvrhhnpedvheeuffehgfeukeeufeeh hefghfeugfefudekjeevudffgeffkeegffffveegheenucffohhmrghinhepvghnthgvrh hprhhishgvuggsrdgtohhmnecuvehluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehm rghilhhfrhhomheprghlvhhhvghrrhgvsegrlhhvhhdrnhhoqdhiphdrohhrghdpnhgspg hrtghpthhtohepgedpmhhouggvpehsmhhtphhouhhtpdhrtghpthhtohepjhhirghnrdhu nhhivhgvrhhsrghlihhthiesghhmrghilhdrtghomhdprhgtphhtthhopehmrghhiheirh hunhesghhmrghilhdrtghomhdprhgtphhtthhopehsrhhinhgrthhhvddufeefsehgmhgr ihhlrdgtohhmpdhrtghpthhtohepphhgshhqlhdqhhgrtghkvghrsheslhhishhtshdrph hoshhtghhrvghsqhhlrdhorhhg X-ME-Proxy: Feedback-ID: ia2694551:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Wed, 19 Feb 2025 16:09:18 -0500 (EST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=alvh.no-ip.org; s=schmee; t=1739999357; bh=8inoTnynehdr6LnR7I07lMhoxUXGhp+iez1Mhiy/9z4=; h=Date:From:To:Cc:Subject:In-Reply-To:From; b=or31lOF0lsWx9JnR3oMNMrqhvpxhJOJtN3HYuwfjgJcZpeLdYhaGE5u/z9Sc36srf AXbJlwz9fz7bIeuIx4ruC7IG4asTUMqGj34EPSd7n4OdllOz1S//t0SjzWtTA7/4Xm oICWSj9mkpDf4qgi4+4QRWHvL5XuFnEHlmRUqIwi9tmB+1aMC7Nq2taO2bo1Q3D7WZ FIukMu4Ty9X0TV3h20Yv5DUXDpGp0aB4q/ISSpNTiOizqiCDZOTDUCd5z2IESrtrEL vdnuluS1B29RntMtQfQlwhRkzi0IDrlPHzDGAYzczqPXnUd15t3Q1esIxsM1UlDBLx Cp68oEZWo69Wg== Received: by schmee.alvh.no-ip.org (Postfix, from userid 1000) id 020898F; Wed, 19 Feb 2025 22:09:16 +0100 (CET) Date: Wed, 19 Feb 2025 22:09:16 +0100 From: =?utf-8?Q?=C3=81lvaro?= Herrera To: Mahendra Singh Thalor Cc: jian he , Srinath Reddy , pgsql-hackers@lists.postgresql.org Subject: Re: Non-text mode for pg_dumpall Message-ID: <202502192109.5ifhfegolh6w@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hello, I think the business with an evergrowing on_exit list needs a different solution than a gigantic array of entries. Maybe it would make sense to restructure that code so that there's a single on_exit item, but there exists a list of per-database entries to clean up which are all done in one call of the function. Then you don't need to change the hardcoded MAX_ON_EXIT_NICELY array size there. I think it would be better to have a preparatory 0001 patch that just moves the code to the new files, without touching anything else, and then the new feature is introduced as a separate 0002 commit. You still have a bunch of XXX items here and there which look to me like they need to be handled before this patch can be considered final, plus the TODOs in the commit message. Please pgindent. Thanks -- Álvaro Herrera Breisgau, Deutschland — https://www.EnterpriseDB.com/ "Porque francamente, si para saber manejarse a uno mismo hubiera que rendir examen... ¿Quién es el machito que tendría carnet?" (Mafalda)