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 1v8xIt-007jVa-Fg for pgsql-bugs@arkaria.postgresql.org; Wed, 15 Oct 2025 08:56:14 +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 1v8xIr-005Mnn-51 for pgsql-bugs@arkaria.postgresql.org; Wed, 15 Oct 2025 08:56:12 +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 1v8xIq-005Mnf-Sj for pgsql-bugs@lists.postgresql.org; Wed, 15 Oct 2025 08:56:11 +0000 Received: from fhigh-a6-smtp.messagingengine.com ([103.168.172.157]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1v8xIn-002I5D-1f for pgsql-bugs@lists.postgresql.org; Wed, 15 Oct 2025 08:56:11 +0000 Received: from phl-compute-03.internal (phl-compute-03.internal [10.202.2.43]) by mailfhigh.phl.internal (Postfix) with ESMTP id 10E9F14000A4; Wed, 15 Oct 2025 04:56:08 -0400 (EDT) Received: from phl-mailfrontend-02 ([10.202.2.163]) by phl-compute-03.internal (MEProxy); Wed, 15 Oct 2025 04:56:08 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=kurilemu.de; h= cc:cc:content-transfer-encoding:content-type:content-type:date :date:from:from:in-reply-to:in-reply-to:message-id:mime-version :reply-to:subject:subject:to:to; s=fm1; t=1760518568; x= 1760604968; bh=sxa/Ivf+mVY7x46p1ltFUoDM7JVn6evrn1g5JJkn48A=; b=k qtTguOE3R1VZlSnlyCCrDmEpAFpUWDhkgHGBDsyJ71tjEf3tHA+qSrAKBdNEjdrm BmIZ+w1prU6iQy5869Vd1GvCZoFd9pCZKqUEPUjkhEdukmPFaaSPiuU1ObPmbFK6 zMvEZfydadT+oVtqUgHCnbi7Fl2eIJGa9FqtmxlHXjRHkQSKo00TmvV6D2OitHSg 4Qv67ea+fnGhNfj8hDZrxngX6akhoGWaGJQHq3c2tIWNXIXyq2N4aq7gSbZg8pV6 MR5pFZY64cVq5O/++A8LGdXiyOprIYeuVpx6LSP5I1tNa4HGwwr3qvLdnZoNA/kM oXDez1HsRKCtq31AAeO1A== 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=fm2; t=1760518568; x=1760604968; bh=s xa/Ivf+mVY7x46p1ltFUoDM7JVn6evrn1g5JJkn48A=; b=cveMdDb+WeeHddqwJ glBjirucOLOI+e+j5Lh+/cNTkfOGjcsYhLbkZLPLDr+U1UnwvvsaFEYdF7wuGp0b wV9pFL8WUK98pUeA5lqUaLQy0NKWrTcUCiHjw76AkOzedW0FmkUCqQHYGJfhIMYO 2pNukpZwIrKQSzZLgFhNIPU9NEC8DNNyGzyjn/r+P/P860/NEpgMMjmAQWJOsrDQ 5AHymFM9ziHPBRvno30sXkFcb1WmcKxdUmsQdkeLioQ2Lv89HzgIApV118NRMzoj q0TD7WEvSyYMf7nZnZicLQ9UnhVKy+dyTF2mOq1/ypCFoUSRhCcqL/U3SHtYEN0G FsuNA== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeeffedrtdeggdduvddvleelucetufdoteggodetrf dotffvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfurfetoffkrfgpnffqhgenuceu rghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmnecujf gurhepfffhvfevuffkgggtugfgjgesthekredttddtjeenucfhrhhomheplmhlvhgrrhho ucfjvghrrhgvrhgruceorghlvhhhvghrrhgvsehkuhhrihhlvghmuhdruggvqeenucggtf frrghtthgvrhhnpeetuedvheffkeevgfeuheevteevkefggedttdeufeeuheduuddthfef fffhjeefffenucffohhmrghinhepvghnthgvrhhprhhishgvuggsrdgtohhmnecuvehluh hsthgvrhfuihiivgeptdenucfrrghrrghmpehmrghilhhfrhhomheprghlvhhhvghrrhgv sehkuhhrihhlvghmuhdruggvpdhnsggprhgtphhtthhopeefpdhmohguvgepshhmthhpoh huthdprhgtphhtthhopegrnhgurhgvfigsihhllhgvsehgmhgrihhlrdgtohhmpdhrtghp thhtohepnhgrthhhrghnuggsohhsshgrrhhtsehgmhgrihhlrdgtohhmpdhrtghpthhtoh epphhgshhqlhdqsghughhssehlihhsthhsrdhpohhsthhgrhgvshhqlhdrohhrgh X-ME-Proxy: Feedback-ID: ie3de48e3:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Wed, 15 Oct 2025 04:56:07 -0400 (EDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=kurilemu.de; s=schmee; t=1760518566; bh=1VL5yLCLa1nYkfcwudOV/UJ4jU3HZAlW6ihcpSVlT9g=; h=Date:From:To:Cc:Subject:In-Reply-To:From; b=8zgPL7jNM5X7dNWRJyM+bJ8LkyOjp7wPakspuqAp7Ma3Ohn2gPiN5wQvfjBqVe1Vf SFmtsS8cFyvSNUI7UpTVCJNeZBWFCoiPkGiuOLnHv8oRyrnh/gV5C61Irjh7lj+DTE wmacqF5Bm/tgbdF/qydMEzPWQRfvO1rt56lOAQd1o2TMocZuAKNH8PbiRdsx562sVs q4kN/C+SxFX6VuDov9G9NqNKrlY7Z+BH1RGWG6gItWPnw9sIdUm3gsNUlr6YwzdcQL IKjy1cazyJCBBwCfh0Tp0Dt7h1B8ouxVyuFge/9YWY8EiKiXz7WxqdkKsDdtcas0h9 sqpr1hAQt7UZA== Received: by schmee.kurilemu.internal (Postfix, from userid 1000) id 166B276; Wed, 15 Oct 2025 10:56:06 +0200 (CEST) Date: Wed, 15 Oct 2025 10:56:06 +0200 From: =?utf-8?Q?=C3=81lvaro?= Herrera To: Andrew Bille Cc: Nathan Bossart , pgsql-bugs@lists.postgresql.org Subject: Re: BUG #19086: pg_dump --data-only selects and do not uses index definitions for the dumped tables. Message-ID: <202510150855.xloserzoobhu@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 On 2025-Oct-15, Andrew Bille wrote: > > Is this a hypothetical problem or something you've experienced? > > The problem is real: when trying to rescue data from a large corrupted > database, we couldn't wait for the index definition query for more than 3 > hours. Maybe it'd be reasonable to start the recovery by doing VACUUM FULL of all/some system catalogs. -- Álvaro Herrera PostgreSQL Developer — https://www.EnterpriseDB.com/