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 1viBAL-00HWqU-2O for pgsql-hackers@arkaria.postgresql.org; Tue, 20 Jan 2026 12:49:02 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1viBAJ-001BOh-33 for pgsql-hackers@arkaria.postgresql.org; Tue, 20 Jan 2026 12:49:00 +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 1viBAJ-001BOY-22 for pgsql-hackers@lists.postgresql.org; Tue, 20 Jan 2026 12:48:59 +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.96) (envelope-from ) id 1viBAH-001WZ6-2A for pgsql-hackers@lists.postgresql.org; Tue, 20 Jan 2026 12:48:59 +0000 Received: by mail-qt1-x835.google.com with SMTP id d75a77b69052e-501511aa012so402601cf.0 for ; Tue, 20 Jan 2026 04:48:57 -0800 (PST) ARC-Seal: i=1; a=rsa-sha256; t=1768913336; cv=none; d=google.com; s=arc-20240605; b=A7KPin9YveF0R3OboW3YjjKGNuUVstYXWYDgHU9WZ1lx4Nx5nED/jSm4HicaianE8b 8CI58zzp+PaJZeH6hX5zAkOhLL17Ss7tXJ+jPKvBOuxDECs2+59BSk/juXINm1N3rPG2 fGB1LKPMdxZFQwVcVKY17GWooSRDDW6baNPoasRMN2oFrtSKNeHmbRza31xg962iYTsC EYQOsoxezeEtj7bUSryvw3ZbSLrXfi1m6t8dhR1Rbjgw0DDrsa6JK//qWAUgdNyfubI9 ulTF8FvN4AFpIo8Xu41XINiz7PzFvFrbFfIbkqGHN5w0HcPR9KzEDM8L8+poadGG1d56 esGQ== 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=OfN1PP8kX5hqlgTIyE3lIC0x01hbUhIRyQw32otOCU0=; fh=xCtHegF1WGIgCYGdVYNmqRGBYXdIm/wd88EnoHQ9m68=; b=Ukl0Lgdd9vzBZs1nvcJm1LLcP3+xe8EYLJd8KKxSQW/dz/6pNQhJ933a90J4rsAgoo M/Hd1OtAMvSTOn5BKpjZjvikMQBow5+DLsVxkH63XPXwarUTW2QInu/EcJ05uJu8wmto 9Ryl6AmUjDwmoYHo4vOJOjBDrpx9Lq8yS49NzavQtJpxBvbg98/SMThH91QbkTZWpO6V hP8NRCmp04Vk5h5jgL4A5XxgaIfYG1AVm3QSQXQpKW3DENdQyENw5+MVI8pqaqifRDpO 0viBWlji6TaZyroIVuJjyDQ1kFcnX87IozCp5IJ43TkHtwdgOCa+LCyWhwgH02zkWWCe L01A==; 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=1768913336; x=1769518136; 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=OfN1PP8kX5hqlgTIyE3lIC0x01hbUhIRyQw32otOCU0=; b=zGH/ExGzAVxSnIsLk+GdhfdsrXjzJ0l5qfCxiiJrzrkq0uUR7W+jeU8g8LrasvyDwb /oHsTWYmR6oVRtn0Oq6O2xj2vJ0BCl3K76WOhOP3hCiaNQ2OT2NdxssV6oLKSIeZbnGg I/R4FVd39cyMaBhYbvDXcQTZt1wY3h/3yQw2z+fuPkW/72MyboWdCYNv036Bvf5qVjUd q4dPjlJhA95iqzL6UUxK7djNAvrk4JlbD9YNt0N4wYWe3AYhfMnAdidm1XgG7Hos/rP+ SK/hymQ0hxys7Leiy59m73Ql4EQfC1FdaKorGJggqfEtaNR+acT/U5K432MhpcCcwqCO 00xQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1768913336; x=1769518136; 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=OfN1PP8kX5hqlgTIyE3lIC0x01hbUhIRyQw32otOCU0=; b=keud8F8agCkF6APVDZGZASWvM8J5rGV/YfOMyEzvfHcZ2kjFJF5yqRdlsRyx9IAlL3 8Hrz9KJm3I+m1c6h0XonFJVlZBcF/LDXb3TwPxqdh2SiswNS280yaQabP288Fdd5rnjt MOZCLlq1VwjCaMILxHqgAAgEEOEe5WGm/Ahfxoo8+183YcQLjXpB4R+XWzgHvgexLpmp LsvIM90mTKFdKb6d7Vhk/SImmdQ2qxZ0IjBo2UCcI0hEV70FzC0igWV75FmCngghEd47 GaBTOa0qZJfzv4aFlsPxHHEl34g7x1OhmChz6LbQAPYg72bYqfGgg3c6qxhXfkFgQh0L u8lw== X-Forwarded-Encrypted: i=1; AJvYcCWuCtx4v0aUAgXlamvyxPPr1+cdTPYOiCDHdKcXrVLqIiWfYxZd0lO+Z4iKwgtSpGjof560ksy7c6FuRVkS@lists.postgresql.org X-Gm-Message-State: AOJu0Yz4S+5zBSPD3DnQuRGT1RPzISnTrPq2o6SFYt/VIk42Azmff3gC k9J9A/fahvanXzcbJNOunoGdarrmeKBX6NB9KKdkMOWzpLYA9Tztv3F0ha5IZGUYJ1fDxEifzh5 6epY4RTLJdbj3xGp9KZgVRrkbwsNRpZ2++MbsRx+Y X-Gm-Gg: AY/fxX4XfRGRZTuwm+qQ71fycVcgkRPHRR+j53Js28vrYh42btDUsEVxX9a47Q4F8aM ZSzhuqlAKUgVk6qupfzrlI67Y6y97Fv45vsGcvJpeJjkWNzkkatlVcgMgIfgVYgRb8GfTTBhqHy NaSHZikQzvSLMZyGjC1uxBLLeM9RwvMRx0fWeRJE/h3MSzPm6Sn9IbRhphLQnWkpnMLvtSd5JGs uF4QxesoFCfTn6dPE68k5fSb5OfPoFNwXReUQob1rpnilUnh0W14JESQ1pa8sb982QMTF4t X-Received: by 2002:ac8:7f8e:0:b0:501:19b9:42e9 with SMTP id d75a77b69052e-502af9d943bmr30422651cf.4.1768913335785; Tue, 20 Jan 2026 04:48:55 -0800 (PST) MIME-Version: 1.0 References: In-Reply-To: From: Hannu Krosing Date: Tue, 20 Jan 2026 13:48:44 +0100 X-Gm-Features: AZwV_Qj_CT1VTJCBJl3AAZJZBMnX6m4lAShyad8m10QPvdsPbor3iIl9MfqLFgo Message-ID: Subject: Re: Patch: dumping tables data in multiple chunks in pg_dump To: Zsolt Parragi Cc: David Rowley , 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 Tue, Jan 20, 2026 at 7:14=E2=80=AFAM Zsolt Parragi wrote: > > 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) Thanks, a good catch :)