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.96) (envelope-from ) id 1vlDAr-008ttl-0z for pgsql-hackers@arkaria.postgresql.org; Wed, 28 Jan 2026 21:34:05 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vlDAq-003zaV-1R for pgsql-hackers@arkaria.postgresql.org; Wed, 28 Jan 2026 21:34:04 +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.96) (envelope-from ) id 1vlDAq-003zaL-0U for pgsql-hackers@lists.postgresql.org; Wed, 28 Jan 2026 21:34:04 +0000 Received: from mail-qt1-x835.google.com ([2607:f8b0:4864:20::835]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1vlDAo-00000000whS-1GGI for pgsql-hackers@lists.postgresql.org; Wed, 28 Jan 2026 21:34:04 +0000 Received: by mail-qt1-x835.google.com with SMTP id d75a77b69052e-5033b0b6eabso31741cf.1 for ; Wed, 28 Jan 2026 13:34:02 -0800 (PST) ARC-Seal: i=1; a=rsa-sha256; t=1769636041; cv=none; d=google.com; s=arc-20240605; b=SaZoe0USM5jN5s52hs9o3XjQPb3CFfEeIfjUnPERRHpuOu3FV0QbTQcrQKA5bkD9p0 di1Ce0cgf3pzsmP5O4dDu/wSarWkeJhXjxTO/qw5nCUnW4RlyzJacQO3sThlAJxWoATC C6S7Dtwsjsbe75oJ1k8mMSFQxyZzrEUOxvV0rao1B0NaLoZHZ3a+aU1nTcC4DS4wjhmW IfGZP/HZfOhkORU28kgTDFlquoJ7vm5vn7Cga/Xe/uSJ9Oxd0YMfiom3GwI1+ZUuYVHT ootSpbfd9tdS0PcQhDJfD4awtExxCv/NbU3LpC1DZXOqnYON4/hK+HMmutsQQ89CJlz0 zyiA== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:dkim-signature; bh=I3WP57KcmxlzRFlule1Tp4+0LjNsyf+1izzUH1azXBw=; fh=Tt9m0Bos5LWUeY0l+Ul49UaMhY9s13Nk+NzF1B8Vqps=; b=eE27GShA0pkzy4ycbkgRXXI2S9UwsOM7kcKQI5dLWfxcQbj8rASA++utmwyYe8k/7K OWaj+nTReU41uFwIR2LSDXwfCd7bMaDiNkr9p1nvdTOcMba9pG0DlrXqOvhhvZ7mUBbZ JdCupHAaxk6T4BpQZXHI+ICHijm1MXGvx2dq8tkrOID+TJVPtuA95QGToshtmLdowRpK 3TzM63bzkjBWvi4URxt/Gkc+eGvQubcig0U5oBnjUrSKDgHA4Ib4EMNKlKq/PrIjtmD+ tVJl13balPYGtaV3YpqhnA2rSF8x8gkaly+50nIPiZVDyx8WA7DOAex9b89vm2ntLFcQ i6ag==; darn=lists.postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=20230601; t=1769636041; x=1770240841; darn=lists.postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=I3WP57KcmxlzRFlule1Tp4+0LjNsyf+1izzUH1azXBw=; b=VkxcdCgJ00AQGGem3xiDW0NfTwb5ZmkH2p3u/3b9qTlNQpq4SZaL0zQpWPjS7yI72s hvAWRT3u2dJKMFJJsAs4dkxeNfzKe31Apxa7HrQv9ZocOFoCY0mv68v3VwiKPDkRKSzx jDoune/nyvDsIIgP5WKbcH+RUvXnrOr1wzr1rz8S0J+zwrgiJE7zL0bC52FGqMSxAuTY DVX45JJoRgbkrOrQ+x875CBgcca2Gxwcd1SMj2Bl/H6glxebGRqI0APc/u4NGrcP+HHn M0H5yP+XyRxr5D9THoNMsUGFkmglpNBkH1PxTJtIYlYC1KnwPlIUopZjwyo5eLEHJs3D zfgQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1769636041; x=1770240841; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:x-gm-gg:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=I3WP57KcmxlzRFlule1Tp4+0LjNsyf+1izzUH1azXBw=; b=L8xh2ObHHAyhdttmAlTyIbgRg0DCDNyWf/UiHsfsBPjxRnLMWujdHR6EZzdiDnJIPD PutZMU454N1266rcTMO/u+xpSXskODJJLb9WhFdnzmfnZOq2ah4DXx0hWPobUX6At2fq x4K6yOz7bgGxKNm5KCWCu7X8WxZm4cgoW3nxK065HSyWRtoy/GXuRDRQoD9cxB/dkMTY ZhxfTCOpBE3LGdM/xR2M6bj5+lEYcGS8pjLmnAkOoHwD99hOKDcOQPZz+njgL2b0rAUB QQN5iWQt7bL+328luzPehjWczQCUXs7CQq/cEz9h4MxRS3an7dnBfd7tYd7kgll8iIXP CuVw== X-Forwarded-Encrypted: i=1; AJvYcCUIwpIv0uOAs3sfpN8HRRcVEl2+IGnWvWaNMW5eL8G4Xo9LcRsI/QcM6xnmnahA7JUNqy+QbFQ0D0XtuIIg@lists.postgresql.org X-Gm-Message-State: AOJu0YwUXNytCz2DcCjiuZU9EVr8a5G9Ub9B20KTq21FVf5CPIsIqDDj vP6SjOY8WJxxSoBx+QgN6npawQoKLCz20v3xL8kDmJprSwsVvGoIIvQ38bLIaVp7nH+bwvHuZrm QAOz5EvH9oK53T9yPMN4DCxznkQ7QQ8czCqFhU4+I X-Gm-Gg: AZuq6aLmJaROI8IpyyhZd7Ousl3Oh9mq3t1LwlqL1N68gRRHX/TrQyCelvbwleFdU1t Pmr7iRHlGcbtQSbDog441YqWUYm9zE3gN8b4UVTi1XBMzG3lV41RfrH4REQuTgxEoFG+ZfflTbU yZJM+AnOx6j2hBVxe9ed3jF8ovUw2JZPltckcxya6hDAFWF2EEAX56AEkKsan+QoXHW+79LujOG nthYME9l4bChKkMsg0i1Rja6CxqXREm4wgTCI5vZdLzXWeqZSSz/XIGsxRgotHYERYRtA== X-Received: by 2002:a05:622a:1819:b0:4f1:a61a:1e8 with SMTP id d75a77b69052e-503b6706a1amr2606781cf.10.1769636040399; Wed, 28 Jan 2026 13:34:00 -0800 (PST) MIME-Version: 1.0 References: In-Reply-To: From: Hannu Krosing Date: Wed, 28 Jan 2026 22:33:48 +0100 X-Gm-Features: AZwV_QhHlASPaTfrLtImyMMhO9iPNeArMr0YxikebofZTcyI7qytwQU6QJvmrtY Message-ID: Subject: Re: Patch: dumping tables data in multiple chunks in pg_dump To: David Rowley Cc: Zsolt Parragi , Ashutosh Bapat , PostgreSQL Hackers , Nathan Bossart Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Wed, Jan 28, 2026 at 10:27=E2=80=AFPM Hannu Krosing = wrote: > > Hi David > > About documentation : > > On Fri, Jan 23, 2026 at 3:15=E2=80=AFAM David Rowley wrote: > > > > Aside from that, nothing in the documentation mentions that this is > > for "heap" tables only. On re-reading I finally understood what you meant - that the chunking applies to only standard postgreSQL TAM called "heap" Will add that as well. Would something like work "This flag applies only to tables that use the standard PostgreSQL Table Access Method (TAM) called "heap". The tables that are using any custom TAM are dumped as if --max-table-segment-pages was not set." --- Hannu