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 1vi50E-00ELFG-2Z for pgsql-hackers@arkaria.postgresql.org; Tue, 20 Jan 2026 06:14:11 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vi50D-00GHpR-2x for pgsql-hackers@arkaria.postgresql.org; Tue, 20 Jan 2026 06:14:10 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vi50D-00GHpE-1q for pgsql-hackers@lists.postgresql.org; Tue, 20 Jan 2026 06:14:09 +0000 Received: from mail-yw1-x1133.google.com ([2607:f8b0:4864:20::1133]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vi50A-001MvZ-0e for pgsql-hackers@lists.postgresql.org; Tue, 20 Jan 2026 06:14:09 +0000 Received: by mail-yw1-x1133.google.com with SMTP id 00721157ae682-78fb6c7874cso54566257b3.0 for ; Mon, 19 Jan 2026 22:14:06 -0800 (PST) ARC-Seal: i=1; a=rsa-sha256; t=1768889646; cv=none; d=google.com; s=arc-20240605; b=CdQcICdeB4quqS4QezpntOUSg5LeLNSZAD1QCm8GhM+qa5GnbyK1Srhr5/555pHwWB HtyNnhR0+3AbfUxUhWh8bnkY3kMEywbQS/tz0mS3NsZDjlgMKxkd8S+CXp8aItNU48EI mphf10lGvAIlw87JVkreRA/OjYjlEnWCfF7qFzND/i9Khn9zKpsabcm9oStXfgjrwFfv gFRSLmPmKaVjCgjEkiD2LVUWX30kXvHtgTsKfnR0CzQbr8/elgYiAD8MT635zvuN4auQ Egh/Uywv0JO4LKKuzoJxCDtQ20xDooeKNWebvUgajY6wnSFK+xyox+ZMtqKVOv4bj8cc 4DZw== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:dkim-signature; bh=WaCPNMippCMYFyuKdhtRo73lrqg2yqhmkEgItwDNsCk=; fh=s5Rc3yjSxtac6BspjCOEETwMq95J5R4+6Dx9tOm3pKk=; b=QNMk0djwvZ7SL5S8sJ2XnRjPdq08IBewmEzu9BEeWZfp9iTA8pkKUJKDOOggPVeRBr O5c8/l7plIR/aWZIeLv1QzNVy+43Mk4SFlxAY+LB6cvCnWHpNGjbKIYLf2Yq7AEuvehj ztQn2lyGgSCZXNF0bZSv0KO/wsA0VPNl73ZGvBSlKAelSpt3e9L/tSX43fCew7q4R794 leanndgtSSE35pfpV9YjHCq1IJ9XfK+c1E7dHsyW5+qaTUYZvWuOpKRFh3HRcwXRxtQo qYDnMmkdYUHROMtiujinA3PhcYuB18dA1zz70VVc0FY+WmIzP9+Qt0CK3sp7uSQ2vhe7 sRVQ==; 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=percona.com; s=google; t=1768889646; x=1769494446; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=WaCPNMippCMYFyuKdhtRo73lrqg2yqhmkEgItwDNsCk=; b=IPbG5jsRvc8rtCyJBH0imIgpvV1hpV0HG50JhdH8XvFs0fMTncnyoElfRgNJEyAZB7 WsG/zDq6mOaPVmU8jxL7aSWzUqgtfPEBRu6cpZ1q5ikK2HpbAOAk2MTwjhkYhF4DwVva Z6sV9dHpsPStXL4B5qDJYSz8Gf/XCBfzGRkyM= X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1768889646; x=1769494446; h=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=WaCPNMippCMYFyuKdhtRo73lrqg2yqhmkEgItwDNsCk=; b=gMWPLc9KdpATe1fBoZMEjiEEeKtUsksqD3b87799iTdbM3cCe13XR93kwqnCquYZdB JkmIqoDzWYvH9GeztDNZ9cptEfZos/vEhJtdMs1u0ZB/GIXr+DR31oVV3WXwXx1beItp rBCzuRARnxqT9MytPvNLpGouPUkMFmIyGZH/7P1QrlHxrXWbs6lS0+ZTmg5JMH8VBsM2 FCJ5HBp1GDjomnoeIlcMkJShS43C/swWcdsz6PLsKD3n8aykhVH7fm7gfEUAve54WY1o L/YeBO2sZI14JWoPmwtEzIzy3b9PCTK9dod0cdelmoF+PYA+McUd3OV1rjxB8JNmh5EK KdeA== X-Forwarded-Encrypted: i=1; AJvYcCXQD115ZOIgQGsmfoHyxpc1FqTIQgI3DOfOU5JnJb57Rq0DjCyQ3BX7Ga4K7lvXeZnfJcds1pI8cAJHHi5H@lists.postgresql.org X-Gm-Message-State: AOJu0Yw+9PqKbmeIDN8/KSUvCx+WAStE1UFgCVxBDH3UDGEqEduB2HL4 in1DusASuY32CUKQ2krBXmmzEVIwOcfDzdgsjRyJD7n/sKurBRggHeaODlCjnAU2reAfyc+3K0h iGdSf/FmI81n3j4F6vXpW4vno+wN0xEvx77DkQRPIfhtowP8uHja0DFJklwaIkvT/qK3Ug7Cfqn +X2T7Jl8B9xoXhygQTvjGK0snw55K0f/81MDulmY0CayrLm5HfWyofR8yB5jD2tGZ7HPLJfY0A/ DrJExs0wr8UppFzETyYHFlswO3RNYXqqG+aN6Bq+eIj1ZfUsIwHzj+6Q7gXgEinqB4= X-Gm-Gg: AZuq6aLhXctYw060B+oXl4dQb6LHHIyOmE+tG8kpb2yY1Sit20MeJSW/vgIxB/OC1vH O70bGzVmMYgjnC12yCHgHiVeFeOj9cWk4nk5AQoKAxfUQQnmJgon2HiH7F+0pYrrCcXh42P34iX Q7gPil9ACELdfwi4wSM8obWIj0LN1e0wd7frJ5T2nJPGXZbvUZm+e+GZ94z9Hcn8MY4BKG1ZAqH H8UUh7hJaitrACa296rwab2EtjTmJybBiG8JtOCq3bqZOEFHJq8foDbf8cGVo8gxPOkVacAz6Lb jMeN+kFeY+02M7Lg/U5hyswh9f8GafhqsgbDayhcB+wUiT8bdHKFqasu X-Received: by 2002:a05:690c:dc3:b0:78d:6657:fd01 with SMTP id 00721157ae682-793c66adafemr108040577b3.12.1768889646066; Mon, 19 Jan 2026 22:14:06 -0800 (PST) MIME-Version: 1.0 References: In-Reply-To: From: Zsolt Parragi Date: Tue, 20 Jan 2026 06:13:56 +0000 X-Gm-Features: AZwV_QjPuu_Ou1FnuPVF-tRzHOQ7301-fgRryrC4V8IxGGgq8wagwk3lmAUhw2c Message-ID: Subject: Re: Patch: dumping tables data in multiple chunks in pg_dump To: Hannu Krosing Cc: David Rowley , Ashutosh Bapat , PostgreSQL Hackers , Nathan Bossart Content-Type: text/plain; charset="UTF-8" X-CLOUD-SEC-AV-Sent: true X-CLOUD-SEC-AV-Info: percona,google_mail,monitor X-Gm-Spam: 0 X-Gm-Phishy: 0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hello I changed two things on the line in my previous email, I think c.tableoid is also wrong, pg_relation_size(c.tableoid) will return the size of pg_class, not the size of the relation in question, that should be pg_relation_size(c.oid)