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 1vhwbG-00AiLU-1y for pgsql-hackers@arkaria.postgresql.org; Mon, 19 Jan 2026 21:15:51 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vhwbF-00EcmP-2I for pgsql-hackers@arkaria.postgresql.org; Mon, 19 Jan 2026 21:15:50 +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 1vhwbF-00EcmH-1K for pgsql-hackers@lists.postgresql.org; Mon, 19 Jan 2026 21:15:49 +0000 Received: from mail-yw1-x112f.google.com ([2607:f8b0:4864:20::112f]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vhwbD-001Ooh-1J for pgsql-hackers@lists.postgresql.org; Mon, 19 Jan 2026 21:15:49 +0000 Received: by mail-yw1-x112f.google.com with SMTP id 00721157ae682-7939e7b648aso46492017b3.1 for ; Mon, 19 Jan 2026 13:15:46 -0800 (PST) ARC-Seal: i=1; a=rsa-sha256; t=1768857345; cv=none; d=google.com; s=arc-20240605; b=Bh++bKESu5Gt4Zm4+KW7LleQN/TJCkrCAuXlS4jueHawe/4NVRUZmGQq9DvrFt4qgh +1+vJkY3uwleFKODilZKPSCzYmUjNh2GhVPDo0VOU0kFCTJPSQrHmSCgI1mY9tDzQ7zg 16LiNh5JgrBxsIGRdyk+cUHX/HUQX9K/rqXP2DVrwskImoerrENImV5xFx529VOwql8c Z+K/keYKssKHRWaNV0dt+xF1Hk8swF2XM308ygaoM30FbQsgCbv+439mwgGqo/L4pcQ3 xySDNQtb8HDy5I/bAV4+IXWDKvXWDImozQAQOt+27gNNEjroztKUh/ZZcLYvD9OPFmmU C8Vg== 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=33j18dE4JAhix0g6MWSfz8wXay/EJGQVqrKbLYgGS18=; fh=X4Rss87eQG36xali96XZ+lCPhZ9TvARB+YT0WFJnT3I=; b=KZ9iVJM8SpTFpj3fVrsrT555bhoMDXoannHK8MMfZQnTMgaxHEbP1NQQIUE3M1WgYE ngpjXnnw2pTVxxtmMnKCNlPgqFI2moKFPEbzzgrRvTELn8EZ65bCMD+aCS9DwDhWKr/B MdFTUyGSZfczETPB1a5Dzj6OZkJ8nPzj/grUZwxJ1ViKGGEkNGXCvk4CFox27zbmNvnK DlqKhuNd6CH3oDmlinNk8FoUn3ytZiw4UBwkIt3g4ZC/K1/v/djT+2vrNrCQf1CNmoyu HIzJACoPo9fYIhhZZPxBioe/AmsErDHk+H8vkQcAfYv2C8THbRhEYiX6eIZWVja1yoWR MDnw==; 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=1768857345; x=1769462145; 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=33j18dE4JAhix0g6MWSfz8wXay/EJGQVqrKbLYgGS18=; b=Jq4DszWXIuP6uKfM+JWIIhyEoH1IDuuVkshLAyPtxYJ6brm97LkoxalT5LFBZtCWV1 v+Jnt7X7iB6W4U3jfPmzAFbfB0JM0NILp2XXZObYUDqwJBPYBFv6g2UyqxdZxxZNdjNP Gks03e5t9+5aJvZXRje9KwGFAfTVeISxD9Nzo= X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1768857345; x=1769462145; 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=33j18dE4JAhix0g6MWSfz8wXay/EJGQVqrKbLYgGS18=; b=nyz6JRmbW60/iVsOOK8LtD7IDKdE2Jehi5X6zlrQ3LveoKI/TWHBQjHJ34SgErzwd6 zhsMkvkMNlOwzDtV4W6T6PTIwsIyRoNSgLfGohsUDPvzEv0E4Wi0drwima+6UPjzm+fV ARmEP38G82BuTPkkWpEvFvOHO3BPH1axGcZoqz1cFGCeyUrWhxbb54bkpaqLIomuMO4+ jT/1DV8Ijx3grUXGgq9kbEhKNl8OOL+Aoy5xj3eGAGbJ7xCyhSVExjMTP9vtGkE78/8X 9STfaoNIJ8IFF5NvovTmhOJ+eXQOCpUPpjTz8OUnyBd7cSDdiHhhRL9Tnx50mUOPlhOE uH8g== X-Forwarded-Encrypted: i=1; AJvYcCV3Qc4liKu+OsLm+/7PX9+dIQV4mokAIpdCPGQzW1XQaYeR+Y93WtARIqC7bV7Jdtyp7WKu3xuEYAiRT6jx@lists.postgresql.org X-Gm-Message-State: AOJu0Yw7VFqYzr0VKU0yhMjOCFFTNpUMzJErFmRkTNpe76wq91+Rnnj4 4Q1vIXArZ3Keyjr6AAYG6uPODIPtVEMZn3xQEvbGbpgTUp2yTIzfQYeCNJOqR7nJeJVGaoWjA17 s12RykqIpHIf209S8uJDRUAukXFkuo6WJzJ/Cfesk+pe6g6uQk8EPm6xApBwjgZJxfyVuTpMsX7 sEhpxDKODNdybcmFw8QZ4YwYp7hmLIchE3OcgBrBto1nJtulqXRlw7jxb/sOKfhAOuVR5x8FA/4 B8fqqmxNss2ooXKHg9Hxr41ZlkXFObcG7wBc0kv+wKe96rEjIFYqcZthJ8unBN6NtI= X-Gm-Gg: AZuq6aLczbvWIDC8EI8thHLSQ8I7rW7rlGUe9NGYxjfa2lE64Bw81pD4Ce48mtRql2a 5zv4Rgp+MXhPkHCDp/K4aqKAzLcIqPU2EdbJi1L4aXmKlYKkfGRv6dyHmzXdnNoMef7H6NDbmYF U7MKtsytwx4Pf6jDG3K7usuW3aJeDekMF2m6FINSVyYVUzBpc7Xcoup+n7vL3X/Ehl9+g1hlvvF UNhzFkM0Ur9tIEumyPhRHPtHo1E5zsk8k9jhNTzXcFxaad/ma76xDBo5IPlCGfZxpRaD7/WMF0K e6IaDlqLBI0qBFljgwR2dnAvpr7RAXkJROvVrZH0i9jyHy1RkVY1NRDY X-Received: by 2002:a05:690c:7484:b0:78f:a92d:117d with SMTP id 00721157ae682-793c53a2c44mr88725247b3.47.1768857345262; Mon, 19 Jan 2026 13:15:45 -0800 (PST) MIME-Version: 1.0 References: In-Reply-To: From: Zsolt Parragi Date: Mon, 19 Jan 2026 21:15:33 +0000 X-Gm-Features: AZwV_QheYKUKL6ToaTMR_xBSd_GD41rLQX8MxD_0Vdq28sY-9pk7qI34RclJfUs 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 pgdump.c:7174 + appendPQExpBufferStr(query, "pg_relation_size(c.tableoid)/8192 AS relpages, "); Shouldn't this be something like + appendPQExpBufferStr(query, "pg_relation_size(c.oid)/current_setting('block_size')::int AS relpages, "); instead?