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 1sUtNr-006UeO-Rm for pgsql-admin@arkaria.postgresql.org; Fri, 19 Jul 2024 19:35:15 +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 1sUtNo-004VgZ-C1 for pgsql-admin@arkaria.postgresql.org; Fri, 19 Jul 2024 19:35:12 +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.94.2) (envelope-from ) id 1sUtNn-004VgQ-P7 for pgsql-admin@lists.postgresql.org; Fri, 19 Jul 2024 19:35:12 +0000 Received: from mailout.easymail.ca ([64.68.200.34]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sUtNl-000Q71-LF for pgsql-admin@lists.postgresql.org; Fri, 19 Jul 2024 19:35:10 +0000 Received: from localhost (localhost [127.0.0.1]) by mailout.easymail.ca (Postfix) with ESMTP id E73906198F; Fri, 19 Jul 2024 19:35:07 +0000 (UTC) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=elevated-dev.com; s=easymail; t=1721417707; bh=jbqvXc/M1gX6kOLHRii+zoSqukZA88wefsYESIxnb14=; h=Subject:From:In-Reply-To:Date:Cc:References:To:From; b=id0mk0ke2CobHdAfjUbvJxB6fHcH8mduOiiwe629YJ5HzV0rIMI4qI+1+vSB7Sv3W QK3hXQQLIAYGdJoziXIW7oCKe2BJqdo3XCsl4dqXsHMh5/RVZYzCfNvaF3zvHCFfAf 67UGfih03t/Ug1BlITY9NARqHKm/g6y8hbgkpKhxMs7ab+xHC4pSrJL2S1A3Ya8mDE 7DCn4N1GgEuepYcGlh7VD8BNDEyUZR8HDbGDJVJGnYMNmbNvUmH7k3u935ei0WBlcf 9MN0m/9XARPnM9lmD9+6QIciYfzF+sGiip4/B+eywaYFU5E5HVuahOFcaTOJiXOIsL H//WqNv7fPNSA== X-Virus-Scanned: Debian amavisd-new at emo07-pco.easydns.vpn Received: from mailout.easymail.ca ([127.0.0.1]) by localhost (emo07-pco.easydns.vpn [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 9FdgrhB4RkVB; Fri, 19 Jul 2024 19:35:07 +0000 (UTC) Received: from smtpclient.apple (unknown [165.140.184.195]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by mailout.easymail.ca (Postfix) with ESMTPSA id 625B461989; Fri, 19 Jul 2024 19:35:07 +0000 (UTC) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=elevated-dev.com; s=easymail; t=1721417707; bh=jbqvXc/M1gX6kOLHRii+zoSqukZA88wefsYESIxnb14=; h=Subject:From:In-Reply-To:Date:Cc:References:To:From; b=id0mk0ke2CobHdAfjUbvJxB6fHcH8mduOiiwe629YJ5HzV0rIMI4qI+1+vSB7Sv3W QK3hXQQLIAYGdJoziXIW7oCKe2BJqdo3XCsl4dqXsHMh5/RVZYzCfNvaF3zvHCFfAf 67UGfih03t/Ug1BlITY9NARqHKm/g6y8hbgkpKhxMs7ab+xHC4pSrJL2S1A3Ya8mDE 7DCn4N1GgEuepYcGlh7VD8BNDEyUZR8HDbGDJVJGnYMNmbNvUmH7k3u935ei0WBlcf 9MN0m/9XARPnM9lmD9+6QIciYfzF+sGiip4/B+eywaYFU5E5HVuahOFcaTOJiXOIsL H//WqNv7fPNSA== Content-Type: text/plain; charset=utf-8 Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3774.600.62\)) Subject: Re: Enhance pg_dump multi-threaded streaming (WAS: Re: filesystem full during vacuum - space recovery issues) From: Scott Ribe In-Reply-To: <6107c011-f907-48ba-94e4-884f59c3da1a@talentstack.to> Date: Fri, 19 Jul 2024 13:34:56 -0600 Cc: Pgsql-admin Content-Transfer-Encoding: quoted-printable Message-Id: <970C2168-9B22-41D4-A801-9215BB2EC15F@elevated-dev.com> References: <7dee2c00-6184-49c5-b303-58113c1d04c6@talentstack.to> <95f5bff5-b392-4c2f-9708-8fd5547c620c@talentstack.to> <6F46CFEB-3C3A-4CEC-89DF-57D8225A5863@elevated-dev.com> <6107c011-f907-48ba-94e4-884f59c3da1a@talentstack.to> To: Thomas Simpson X-Mailer: Apple Mail (2.3774.600.62) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk > On Jul 19, 2024, at 7:46=E2=80=AFAM, Thomas Simpson = wrote: >=20 > I realize some of the background was snipped on what I sent to the = hacker list, I'll try to fill in the details. I was gone from my computer for a day and lost track of the thread. Perhaps logical replication could help you out here?=