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 1urFSa-00313c-8D for pgsql-general@arkaria.postgresql.org; Wed, 27 Aug 2025 12:41:05 +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 1urFSX-00F0w2-W7 for pgsql-general@arkaria.postgresql.org; Wed, 27 Aug 2025 12:41:02 +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 1urFSX-00F0vs-IA for pgsql-general@lists.postgresql.org; Wed, 27 Aug 2025 12:41:02 +0000 Received: from mout.gmx.net ([212.227.15.15]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1urFSV-0028nh-2m for pgsql-general@lists.postgresql.org; Wed, 27 Aug 2025 12:41:01 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmx.net; s=s31663417; t=1756298458; x=1756903258; i=jimis@gmx.net; bh=Y6LuyYRSOQ/TL/aARXnvKZNGTcKL4vm2MQG8WGOKjBQ=; h=X-UI-Sender-Class:Date:From:To:cc:Subject:In-Reply-To:Message-ID: References:MIME-Version:Content-Type:cc:content-transfer-encoding: content-type:date:from:message-id:mime-version:reply-to:subject: to; b=J65Sg+lfi8Yomy95CMl0lEqDjgA2p85RaZ1YMjhMv+Shbg+EN6UBQ/q50kUVNoKo YMgRdBBUrF3VgbZKOeLiU1AiQrUUlFcveTk0Sicc7XBGXc5IGh1MeewDbtuuuPb9o C0zehUWUuoYh1a+Aq/qvRrcmABHT2Mt/l07WmO0zMaGf10hFjOU2hbWlv3sfPhUmR OBAsbKr76wiQTIQiRaEQ87Rf9dwNPxSIwSINrCY9sYfuDLZuiRdkRt7PZc2kTjOl1 2f2DxD+W6gJ8Jt1zmAFD3PvLSWXbk1D3ZPgw7DDCsEaAdabOtEjdky3PvyBwYIxKB 9/2Zv8HADmMQdicJ+A== X-UI-Sender-Class: 724b4f7f-cbec-4199-ad4e-598c01a50d3a Received: from [10.9.70.59] ([185.55.106.54]) by mail.gmx.net (mrgmx004 [212.227.17.190]) with ESMTPSA (Nemesis) id 1MhD2O-1uLkO81Ikk-00f32i; Wed, 27 Aug 2025 14:40:58 +0200 Date: Wed, 27 Aug 2025 14:40:57 +0200 (CEST) From: Dimitrios Apostolou To: "David G. Johnston" cc: pgsql-general@lists.postgresql.org Subject: Re: In-order pg_dump (or in-order COPY TO) In-Reply-To: Message-ID: <6n801oq1-r471-0488-pn6s-8nn3o95o9r47@tzk.arg> References: MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="0-433266988-1756298458=:1535142" X-Provags-ID: V03:K1:xSh2dTaUL7s2lhrqHY3uJzR/+HMHUQPh4I+BekJBc9bwPZsB8DM FthOj7LTL/HLWN1Be0bJnaz1ZCDHJioiMm/YvAaPQX4Bk+xibXmzqlntrwicbJoi6FiIGyP naY2CkpsyHPncEkGLREZ9EOMMTLhCFSoDM0vuuILu4kii9Aj4YX7klJK3zseZqXtCGhyfep pv+zi5ocQH+gUsjwCq7DQ== X-Spam-Flag: NO UI-OutboundReport: notjunk:1;M01:P0:xZ51BzIhYls=;8VXATsAN5IcvkYm49X5R1iZgFfP U8XagiSxg+U4M4bfHEApCpcaPDK20MDtRlxeWGgKbcKSXQEFFu+uFaDcylXjTShYPwrKgyUda sBI6N/BK1qcU0yHapM+BUVVxJO8Vtp9wA1VeA40GUVbyW4sH+XzeuyeZmMQyDrrHNXKCThnwS GL2cbZmELhIuoCtKU87RdTXIEn4woDMRnITU8YF+UG8yFAyKEMURVFl8DhJedPJjWQZEgRPpJ ECVlCxXmMOSjBTxQxyN0R8JB7a1NQLiwc/7HVvEBw45Ml8mJ9qD3hU6k32tOviW7Ofyj70+EE ZtCIDFVUKmvus9TOQl5BNt7nvABrn9FAXo4BCBORu6SKCXepPlmLaghmpgPcZUW4Luu+dZKmd sKbfkdSo49UAEe0P2kBR9HY2hQzZQRBkEbLt1l+//gS+cGApvxH9K7FS101IorZoUolNZKL+V N0Jda2VOED5n+3s3huiWv3UkqdWu5QIgaERwR97MYfA7S/OgfG7K9Qrx02ys0dUfErTuhJaDY 1ww3r5zwPzQ/9STWvpxLfWpPx+9sW3QzHag98jjPsKOIYl1smfIA9ui8EmUsLXvu2D8Fu2Sfm UIHEL+l8PjH6J8XzgJjGEyXcB9fzZjtmsZqKRxRcP9s9k1ZGqNtzeRuvwtw1gfoPkEpL0eUc9 UctbHq5DMjw3CJc+Ldc6AHo4RzoSN/wbbntiONgf5VIc7Xe92usnufEj+9pDjE1VJg+QEcTf6 EETDYpKD38Al80EIdeVZTv1FzuzkEeu8V1h6uT3hPApGggpWPtNuqLyCxhp6XSB0T8r2MzwpK 25GBF8iGyIx9w9rnvYkExzd9sylnmUZTQbldAt3ApaqIyCffiX9PMGjPq2ZXPmjVItgyGxYMT TIJD051OR8YuXR/fg29MFEHcJzzd/vUCLV2WM2mAQxY3eurRfs+FGcyj974qWhwuR48x27gig +mE2su9t9+M8gDiZkNJctRUeN95c0xRgf80blKzOMMX1LlcRvpGzJBC9P+wMFVWyjeO+bfGXR MNredet+3r6Ic6xe+9X2jvYzg0UH5WTCuSjxuqg9Ws1fd6io4qYkAVXnUWvREdrZOR7r8fmL3 7ngvAmxsIAQIxUzBit+2w7Lj1X+044GlUCeETXc4xXe6nFzmSCuQ5unBpcfjzwwqEZKGM85LN xuGsmmUmp0RNUsO4cXlxxJ5O2KFJPS6aZqPw24sJw4WBpDTrVjTAoZiqIUgHioaCBO3SLJ/yY bZwwYKH40LRyk8GUw6ASyqx7Rq7N2wKCxfrDr/J0GR0y0oSSfHUCbCQBMa85WZlPTWTwfKyR6 mrKZ4LRyi1HxcBsuzAu+BYs3G5OYMm3LpO116fx/9oti/pNWw/AXPV5vSRABcCkUpbkWNG/6U drAceX1GCxfu4F2sgnqZe1WLGsffvCXqC13LLnn+LHVb2h5vUipzbilvKg9UKhqeLfzrTrx2o BNaP9+nGCDts62i6o0EqDucoClYBn4/OUdO9aSQR8zrn2zeRA0FtMgk5dl/fTiEpeShDY9dPR Fp4PT5HVSGjlANSKB1bxcX5U2b2uPh1tvCX0ZlZWzV2ZJRFZD4rPk5v8YaLOM9UbRZV7/eKcw UXJVCaNoko704zAlqo3qXp1zTId4QeQuVOWkSXbuIMp7NU20LgMTOETI110pASgvTIIsVqc8H //7Von1wktXqx2scqtuBSTj5TQjLvTU1fldKPj9Kus6KL+mmiQGPpzv8j3GdA1/IZVNuHLKai WdugoF2B3FdOCtpx5Z3nm2L3ngyYlojAwuMRpXyX5dZWg2s4K9TjTq85IMFGRBdDt/HNZfD1M 6r0S0mJpfmN3ccd6wOzEe5lZX8Uu2lsoR04aZWuqYgqhv0pk+xUszQ19jTKu8vnTR/Et+MWFg Tg4L0OftG/zLrvlBd1F9yyamRCdtcdA2D/COoj9rvKXiWjtJZqvZ+vDYi/zLFsk9Tee4/kcze /e94GBkPlDOBRd9Q6Waek2H3qurGP+CkfZAIrJG79rCZ9nYvO0pavgc0DGpf1P+Z6/WZhIJ7T dvjoEFMKNcT1HZ3SAL9DQvmIgk6xTmO9vUG4DI3/pu8bYkVqDFvNvfl8bCUfR18X/s+ikfOqf zDVKRGO0HjRCqN1T9CSRno/vulODY5XHI9nYcmOfWHt/JSHMepCWJY4az36ZRVrrsm+1UEz4W qNnwKQmcNLq6aqT2uGLcP6bbsWXDa2eX1/AoWVcRethfmH172rHEUqXDNbcGRbNdS7CpmZ8Iy hJbrRNBLUA1JqcpjDxkmigTTyIssa6nwTQQ9reUpu4sozLPmpPhBbIQ6HVjgom8pzKm+G1F2Z Zux4zKjOkdGgZvfp+MogmRiLF2XG6foShyru7GAax4iLGX+C5pvLJWP73MmKWQBlOk308pyyA d/0wdcKbfXPpgxLOpUNkttxoNW39pcfcyfaMryLGa6K6foOX4jSl/1BQrO0JYSuRRBqoWk4PT gIQXR/ah4gMlvI31d13DTj9ucj+roIarB68fXJoWR56x7K/BRqihQv8vdt9llkzQpSODjvbUR b6kC3bQl+cT+CFa7TY8QF5q8v16/+OrwKN0shiWKlJOctpyjvk7LL3fLF9hnLgFbd2/NWhwkx 3on1urmGA4eiVN7XO/2SQrbMlk8uTD7ulv8w7jTxVfypewvplpNUXi15fFq4XYeB4KfM+w8UO RWI6aPNvTkT2pi7VPlt8aVJY6llGYinNxKZViKOyjhEE/OewQtrrLOoQVQQI+nHnTOMnLf8aN popuA8Q+Tkqa86JtFBxVHT9vTrQfg+H6pKqxqMNlhiQKduseDeFj4ujyftdIWd/08yQBaCrzz sVff3JxJgp0QNlEdrs7HHe6OSXpQcjcz6ftbthC4kciDTYC3OZ71n96nq+DI8FjBK9xs9LUvu TyBNKtwFZb4ePRLogS5e/Z8k1Aq+HKNDmo49cqPJrwJqqko6Cvsk7Boew/yufttrTeDEIX0Jt WmVEHmx+MateptvVl96DXJFiuyCLVSd4sWVJ36+EMtE3DReyApVDMFBAAr4nZslbXF1J3qDsj 1D3VA2AWD+OAD6y3Qy5JlkigXmNPLDya3JwzbuxNRmQmUowYo367p7yKasgFmmgTLWfxHwo/1 XZ0PUaceP2F3ySC1yNYxKNW9HwExKj3jII59WEwV2SN2ZJIsWr3n3FEZ61J8Sv5Qh4K1vIHVV Hk6Dad2f9ba+UkCOZhcsZ57pbGOWKp90LTSDOG09NOyQ0IEYNedWlus77k7nDSwa6u4MRRKsA +cIU9SLGGdDvH3MaME852GxlvRRDfFKb+azu8ceL52+yu+Hs9MI6vlbA2YaWsQkdA4TfVXSM3 Nszp4hkS55BQO2DmxWx2b8JCZG1TBZGON6s+/QNQycZhC25w5iA68ck5bZ8SNW5Ax7v+rp0LS Q1wajXE+ZDruu+3rBMu4bHuStcSaf5N9Qm81cIyRlEJFdJE35q9MGg2RwLnBXXfonFY7atkn1 C6vVLRYd0INDRr6kov3+bV4b8t7/ID+HudPNvbsNqMc95KMm7iGrZDvn3+0+pgEHTTr08xFp3 /VDx4RUR/QxbzFQzyuUmOLMxT59um39zn1u1a2md6NLS62Sx9bqrcthVsMYveLKBun5LYdQKH sfi/olDbv1d6zLNFmAKpcyaYTNG0mG0Ru4vVLb9L3jqsfkl8V5evyD9wvSiaW4Eyqs+tNi/bM QizF9I/KhoOl6xiqF7ZJaE+0ySErEVbf6BZj4Ef+L0HKwVisH8vqP4KRKiKk1zxz3GzCqJhp3 Fh7Y2rFBldQNgyVzVXGClyqZ2Xsuu0eYmwpDOp7LL8Z+hlNDVJPzzwYmLajDJ2KILuFVZSPJl 5DacWJgUr8mZ4QO4WyqbQd0qXoKH+5pOxbcnOyDMvdB2SiTO3fO8t8mXny3kCuYTtkSnmKHP3 qEaPyDvvnEp9t3kqTo3fbXODPhjPTm3QuUSD1hn0QpFRG0wwjSIW2RXRw+N/f84N9+Qj9UsYF N4ZGO6jwVVNounu+/2YjyjYurMrcSuqVfiYQa1mUi76vf3cNWxbcy1cERoK+u9BuBIaQRVPR3 UjUXbZRi26HNeYAvwDbsm2hrQztsPrafH8z1kRa4d5POSx8E10qAWAUOLzuL/5npaZ3ecKGwl BVTRnoMWW9iCxUERh2fabyLq0vhieq3pcpUvLiBdQW0c4J8LEEezuahklsHBvuN9l5uFSBww3 t9RnM/nZHwCltcJ/Kk7O7e/H45MpJVuYXojq+nIvFa2wZw0dhWVn1D4yKZfdJV7giAS1265kc JiLuMSULsUtpN3OnMusSwv3I5hWKRQMFv4Jplaa025fytopUDuOlwBVMCWMc9S1X+acpXVp0T tABHFl/Rupq8qQ/o+NKN25jTcM/2D3U4YYLfuNOE6aiM9s17w2uD2JIPxw6+365wyJR6OI/va bAwnAXsK4CuAZjvVRnD8HjYVnaEpdBB7efQe+SFv2pE9/gda40UbTdJcgarGfeWX1Jk86B3kF TuBZz6ZLA40XAGsB6ITUVd2V6ka10eIEN1DkA8QaYIyQ2ReNeiklsyJ4DyRy5TOOv7EI/b47P vTkcgGwR4RyVoCOlIrsAp/5P2lzz6BF/X6ItIN/QF5fYSJGji6TLrU+Z57c2hLdG/IJGKhMPU Cmr8DGmvcGigI3hbTND+u7uMwFROOxjfZPB6WMSmjQgC/7T023e5I1X+ZlxWjKSB8Dun1qnjt 0wZMEnSNj6OZ0GhxlvLgyVady2pvHvcNkZcG9UI5mvQ6EC2ACA== List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This message is in MIME format. The first part should be readable text, while the remaining parts are likely unreadable without MIME-aware tools. --0-433266988-1756298458=:1535142 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: quoted-printable On Tuesday 2025-08-26 22:31, David G. Johnston wrote: >The logical dump has no ordering - it will come out however it comes out.= =C2=A0 "COPY TO ..." doesn't have an order by clause - there is no= way to make or communicate to it that ordering is important.=C2=A0 For ad= hoc work you can use "COPY TO ..." and put and order by in the que= ry. Thank you, so it's not possible currently. How would "COPY TO" behave for copying very large tables? Would it make sense to optionally have that in pg_dump? Or would it make sense as a new feature, to optionally order "COPY=20
TO ..." based on primary key where available, and use that in=20 pg_dump option? Dimitris --0-433266988-1756298458=:1535142--