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.98.2) (envelope-from ) id 1xPvUI-0000000111P-3RRk for pgsql-bugs@arkaria.postgresql.org; Sun, 08 Nov 2026 05:30:44 +0000 Received: from localhost ([127.0.0.1]:53384 helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.98.2) (envelope-from ) id 1xPvUJ-00000005WRy-0t6U for pgsql-bugs@arkaria.postgresql.org; Sun, 08 Nov 2026 05:30:43 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]:51950) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1xPvUI-00000005WRq-40WC for pgsql-bugs@lists.postgresql.org; Sun, 08 Nov 2026 05:30:42 +0000 Received: from fhigh-b6-smtp.messagingengine.com ([202.12.124.157]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1xPvUG-000000010Bx-37BM for pgsql-bugs@lists.postgresql.org; Sun, 08 Nov 2026 05:30:42 +0000 Received: from phl-compute-01.internal (phl-compute-01.internal [10.202.2.41]) by mailfhigh.stl.internal (Postfix) with ESMTP id 0B3857A00EF for ; Sun, 8 Nov 2026 00:30:39 -0500 (EST) Received: from phl-frontend-03 ([10.202.2.162]) by phl-compute-01.internal (MEProxy); Sun, 08 Nov 2026 00:30:39 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= cc:content-type:content-type:date:date:from:from:in-reply-to :in-reply-to:message-id:mime-version:references:reply-to:subject :subject:to:to; s=fm3; t=1794115838; x=1794202238; bh=euR0hLWg9V BVW9O7y7LG2m3ON6hYiTtDrEVTD6u5dx8=; b=ZulnDdardJzuY81jznUt9hmqbL UIRzonOjftm/Rk6dI5jfso8UTaoKQeN+B4g6k3h06bfub9xXh8CSiU8eN0HdhGab XqWXh1sg8IYj6dDjasJPStR34KSZF8dUDc2xehcbL+PzHS+vt/A1TSIJ+kVhz3Ek jHtEQywis8UdpDOB9PNd/lKS9DiafzT7w+4ZhuXRErHJ7WmEXy3zMJbsigU3ZYhU 1am4vDqtdeVdJ0oX4JuIYnHl0v+vFgRvDuI5eFwRPrTJc0gcZVL0ZHdbgMuTK4vO YG/p8sYa9/jiWJHBo/+bAY8i45vRe+Tn9WO+zsxa/iI0dPVddFk31U9whaFw== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=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:subject:subject:to :to:x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm3; t= 1794115838; x=1794202238; bh=euR0hLWg9VBVW9O7y7LG2m3ON6hYiTtDrEV TD6u5dx8=; b=ZRQ2fTEsXSlB2snAXM5a8IsEXjb1EM/DXJPtAT0+oVTVchD2QXB kDB9mz6ehqnJYIzkh/7yArHfqyE6AYv4UXyyC8UqmJ+ZGZkjR9pZUuGakPGDifi5 G2yw7bLr0O83q9im2qaulAA4wC4+hekEn6w+wcydTKdzuDZujnJdWrOBGyBByP5I hurWbJupiaJ0Z0GOYauaiZhFE90ZbwATx8s4XRhT7KGsRbPr0h6v42F8sqMihWqh DURGRRn5bLjoKac2lhGmaU+CGktUMlRZM6LpupudjV/yTEgOVw6yvfRzAayzxVuw stVQDhYUms1kO7cyi409bLn438DssY6cKmw== X-DKIM2-Info: draft=ietf-dkim-dkim2-spec-09; repo=github.com/dkim2wg/interop; date=2026-11-03; sw=lmtpprox; action=sign d=paquier.xyz a=rsa-sha256; DKIM2-Signature: i=1; m=1; t=1794115838; d=paquier.xyz; mf=PG1pY2hhZWxAcGFxdWllci54eXo+; rt=PHBnc3FsLWJ1Z3NAbGlzdHMucG9zdGdyZXNxbC5vcmc+; s=fm3:rsa-sha256:GdW2pXB0MYpT106KMrhmUkpRQpnR7zCkr201SPDX35rlEu2 qudi/+MKr0ljLR+kHT82YeB0AgK0EjcXOGX9aUejBkltFNxHxjXJ8N1TK1aijKvd awC+D3UopxBZTRldiA0vDnEuGcwhl6hSYqbDXEojxsQFH5JnHYN4bNXnFuCxNYZ7 q/QiL5cbXXvMQtS5O044yh3Kovs5/ur1gvoGCY09+tqy2dlnKeNhktiNH5uAYD6+ TqNGQNCnA4zEzmkEIQd65YaMup92smqWyKEHgyM+3nFDTSEudu6PLoP3NN8cix5v zkwOwCOSF9F3Olh3es05+NqkKKEb53fd3FfU8nQ==; X-DKIM2-Info: draft=ietf-dkim-dkim2-spec-09; repo=github.com/dkim2wg/interop; date=2026-11-03; sw=lmtpprox; action=mi-m=1; hc=11; hn=content-disposition,content-type,date,feedback-id,from, in-reply-to,message-id,mime-version,references,subject,to; Message-Instance: m=1; h=sha256:prXdGsmMVZmV7w5FAj76e0vxBgSDN/N12ONANA6hvT8=:5HBvIqtvJukR7da59ePp1FZUmOPsWLuv6XUA6MZut78=; X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: dmFkZTFItU8s5PW709+s5/aKhcHi7yGHnSlOXiiP2zBTFXXypBOJFSB1cQmNEsYPkAioI8 mC5jX7iqzGjBriYrAPAdidwWASy0ncLmoO2gBjoxKDnL2SwxQoK1VBgI4zszFa5954yc3P fON1dMdf/Caus8AEOvnfbfS3iXpFVhFu4sXZPhGh2ZXIMZsz166zQquUhBCJJfm7NbS6Ec EOljtIkKc5WQNQ56EVOTyDwX39eNATeuD8nQbXnLaenLP/Ik6PlU58JokZ5HnQMeltO/fd f9clm0GaxyBSb1MP+lMADVIGz4R5B3Oc4/noZcLA/ezjjCy/tZ8Na+wjhHsRt9BQZHM5Wu LJjMTe6pHya0NpWA3vqXaq338XiVgnlW7K4nByJ4GJS7yMCvCejMqywnG3OCHPsxu54Am9 Wh3BjDC4/40xUjvn+7Fzi8WhqsZLVNQAxfzgVSYUMdFkyrrHhFOlVo/tRi6/eP/PNgNAkV kAq/P3dRHQ/Fg/6MtyDFau0yaaoOooyfA3tRwQIM03pZ/gJ03TQcUYaMqj+dahLmrCYFVJ 6RvM5TTfhhMWAiwSZJx38wtPtx9ZwSvGn6bZRj1LQNln50D2oG+2hDJy5NR8D9H8B0P2ai 28nXBmZO4numt8Yz+NVQHTI1S6bBtwT59pXfFRbPoKH134H5Xp6sAvbEXKiw X-ME-Proxy: Feedback-ID: i0fe9450f:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Sun, 8 Nov 2026 00:30:37 -0500 (EST) Date: Sun, 8 Nov 2026 14:30:34 +0900 From: Michael Paquier To: 125atishprak@gmail.com, pgsql-bugs@lists.postgresql.org Subject: Re: BUG #19845: pg_dump extended stats break when column numbers change on restore Message-ID: References: <19845-a2a2ac0ba28b3605@postgresql.org> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="oyJM9dWajNMdoGOq" Content-Disposition: inline In-Reply-To: <19845-a2a2ac0ba28b3605@postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --oyJM9dWajNMdoGOq Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Sat, Nov 07, 2026 at 02:19:57PM +0000, PG Bug reporting form wrote: > pg_dump now emits pg_restore_extended_stats() calls, but pg_ndistinct and > pg_dependencies values, and the column order of MCV lists, are tied to > attribute > numbers. A plain dump does not preserve attribute numbers, so the restored > stats > can be lost or, worse, silently applied to the wrong columns. That's a known thing. Being able to preserve logical order of attributes across dump-restore is something that has been proposed in the past, and not something that should be fixed here. This has been mentioned previously, and this answer is the same one as I gave previously. -- Michael --oyJM9dWajNMdoGOq Content-Type: application/pgp-signature; name=signature.asc -----BEGIN PGP SIGNATURE----- iQIzBAEBCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmrwCPoACgkQnvQgOdby QH0K1g/+NYwL4a06NmxtzPactlJPFiLZGxGMr8dGqS0jG0c9m2iICoT8CYU6wQgi UtvEcPo6wzh/qg0OQPoNW3tVZ/QrKkbCw3Fxk3rfQ35KXo2RPixNYyu/0L/WZXNR p2kVmS2yHrItijAqoBUELCxMIwaVN/007kX2QvWd9oYXkHQ6kmKCFIXpi1ZNQcH0 pruW6jW+bc4mEZR1hlvibQtikNOTW9cS+sPbiprgGNCU1w2PDx4eBoj7zkd3LrSC r6XS3GIVsdCGnL7WLlXWVMrcyS/ptQP40KIrJjML3WJZFwaQXQSnYN+9qA5otZ4k w8LZiIQ6JFVwLhokzyn3kiK2R8yRcJ8Yhs9ce4Mxw3x0jOebdinB/k/oyk8F/8wg mhdWe5zUWiztiwdADIhDMd+jl2gOy9LOqSYEP4dHglaW3/napQUeYf5dlNancsgF qSjdXZo31tdx2pL0n0GX7mV5rTdvRUwC3k1TQ4rVNZm0gjqTL/LCyNqnXkT90dXT hQ9S+tLQIsClXu5yqo3Rp49GB1rKMjqh+JWxsQKeYvhk2actIpxY+nsyjuP6reU0 aJv0vLlL/2rB+xoNoiSxnCdKk7mggiA13dLEiwxZB/tYzKexS+U0qLEFOCkXssFa r852NAfBHZqp3RaWsf8qjqlVJ6Yhwm39QpQdOLOvt8SIQtnrH2o= =AtFl -----END PGP SIGNATURE----- --oyJM9dWajNMdoGOq--