Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1p0juq-0003lp-3R for pgsql-general@arkaria.postgresql.org; Thu, 01 Dec 2022 13:47:52 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1p0jun-00041U-Si for pgsql-general@arkaria.postgresql.org; Thu, 01 Dec 2022 13:47:49 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1p0jun-00041L-GG for pgsql-general@lists.postgresql.org; Thu, 01 Dec 2022 13:47:49 +0000 Received: from mail-qt1-x829.google.com ([2607:f8b0:4864:20::829]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1p0juj-0004VV-4f for pgsql-general@lists.postgresql.org; Thu, 01 Dec 2022 13:47:49 +0000 Received: by mail-qt1-x829.google.com with SMTP id e15so991999qts.1 for ; Thu, 01 Dec 2022 05:47:44 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=in-reply-to:from:references:to:content-language:subject:user-agent :mime-version:date:message-id:from:to:cc:subject:date:message-id :reply-to; bh=SncOWh9A9zVRaMPf4XEYv0Q/Hwj7gi+9gvUjsHzAuyE=; b=HyOieMumJkQ8OW8/rC8DyvDOB5ZjCa1F8+E7+EXnOnlweUeJxLLRbXBKCrXdwWLdIM 9UVATMMpfWyycLzsLYE7eWZbWNCiYYmhx6jtiWcFXRaRvF3Mpfru19d0mPvItWBG1Ycj rHIUiPoTEGuBEmnVdaHjqOTcmP4dSHu0VZhZARMvNm8x0BqU3P5SCXsRiST+qfcoMZL4 gSWj/2ymE4wOV2WBgebozUBL3ejNoDvM5dyEbuHL7Xvgm8hrC0DMcBGC9Etv8K1KcBp3 80JjeQu7fe91JHVqySBl3RDqu+smzMkxUnx2cX6FVm0Qq5AmZzMaT4sGbePmRIFZZYW/ 91+g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=in-reply-to:from:references:to:content-language:subject:user-agent :mime-version:date:message-id:x-gm-message-state:from:to:cc:subject :date:message-id:reply-to; bh=SncOWh9A9zVRaMPf4XEYv0Q/Hwj7gi+9gvUjsHzAuyE=; b=CdN7h94Bt7qz75AsmSUyJxkekZ9NSqHTg5kzXZOX4jzkMKgglb/tiiqPjKEjWrXcKB dKFxifcMIq7vFZwnI8bfZ8zjw7irD+38j5yF498SryuuSZo5yqSkodo1q3YHwOSB3tnz dYIruHeZzCgCwgVMJx86WUm/oIHSHktYgUotoTrsZ3qc4oBEHQkH9U+h//ZmFfsQyq01 dD2VPInQfgMTihbn+X5h0I2DOv9JMYDknLhaxY0ZBJv0wLtylcDNAjZafX+ygbJZQotY jPPbcfoTJXm0FrZmbJrvY5wC96ghs53dGuL/BP4R/4NW9XOpwcL+0JKleUO5O3eWxcol 1JDw== X-Gm-Message-State: ANoB5pkHWlkaFJal1z4Orr+ooj0LsW8em5xLeDoYEhkJk8GMW00ydVfc yV8n2zMrXTOZT4QFqmoYANpYz7uM5N/SEg== X-Google-Smtp-Source: AA0mqf5+puWzx/bSnp7j/eqYqD5DrMRkI5L1T2ijwtND6Upt30z7mTlY312djuCdRuSRzqvQIJX1cw== X-Received: by 2002:a05:622a:6002:b0:3a5:8c9a:638f with SMTP id he2-20020a05622a600200b003a58c9a638fmr62718051qtb.350.1669902461226; Thu, 01 Dec 2022 05:47:41 -0800 (PST) Received: from [192.168.2.100] (pool-72-79-30-4.nwrknj.east.verizon.net. [72.79.30.4]) by smtp.gmail.com with ESMTPSA id ay40-20020a05622a22a800b003a57a317c17sm2527113qtb.74.2022.12.01.05.47.40 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Thu, 01 Dec 2022 05:47:40 -0800 (PST) Content-Type: multipart/alternative; boundary="------------fX8mE3MyEn8ueI7xUV00odQq" Message-ID: Date: Thu, 1 Dec 2022 08:47:39 -0500 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.5.0 Subject: Re: postgres large database backup Content-Language: en-US To: pgsql-general@lists.postgresql.org References: <9d50f118-a3dd-565a-41bd-d3056b9b90d6@gmail.com> <592a2c79-9728-e450-ad60-a0df7dd0f214@erven.at> <303273b8-6116-23b2-f26d-866e38ef1c0a@gmail.com> <31e934ad-5e3e-22d4-f8b1-0fdee463eb42@gmail.com> From: Mladen Gogala In-Reply-To: <31e934ad-5e3e-22d4-f8b1-0fdee463eb42@gmail.com> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------fX8mE3MyEn8ueI7xUV00odQq Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit On 11/30/22 20:51, Ron wrote: > ZFS will yes be slower than a raw disk (but that’s not an option for > Pg anyway), and may or may not be faster than a different  filesystem > on a HW RAID volume or storage array volume. It absolutely takes more > care/clue/tuning to get Pg write performance on ZFS, and ZFS does > duplicate some of Pg’s resiliency so there is duplicate work going on. Ron, if this raw device reference is about ASM, Oracle has a file system on top of ASM, called ACFS, and I have been able to run PostgreSQL on top of ACFS. The reason to do that is redundancy. ASM/ACFS with PostgreSQL behaves similarly to Veritas Cluster, when one Postgres cluster goes down, the other one is started. And you don't have to pay for it, unless you start using storage snapshots. That ACFS feature requires a commercial license. -- Mladen Gogala Database Consultant Tel: (347) 321-1217 https://dbwhisperer.wordpress.com --------------fX8mE3MyEn8ueI7xUV00odQq Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit
On 11/30/22 20:51, Ron wrote:
ZFS will yes be slower than a raw disk (but that’s not an option for Pg anyway), and may or may not be faster than a different  filesystem on a HW RAID volume or storage array volume. It absolutely takes more care/clue/tuning to get Pg write performance on ZFS, and ZFS does duplicate some of Pg’s resiliency so there is duplicate work going on.

Ron, if this raw device reference is about ASM, Oracle has a file system on top of ASM, called ACFS, and I have been able to run PostgreSQL on top of ACFS. The reason to do that is redundancy. ASM/ACFS with PostgreSQL behaves similarly to Veritas Cluster, when one Postgres cluster goes down, the other one is started. And you don't have to pay for it, unless you start using storage snapshots. That ACFS feature requires a commercial license.

-- 
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
https://dbwhisperer.wordpress.com
--------------fX8mE3MyEn8ueI7xUV00odQq--