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 1nTjVa-0003LC-Uc for pgsql-admin@arkaria.postgresql.org; Mon, 14 Mar 2022 12:09:07 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nTjUb-0007XY-Mw for pgsql-admin@arkaria.postgresql.org; Mon, 14 Mar 2022 12:08:05 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nTjUb-0007XO-8O for pgsql-admin@lists.postgresql.org; Mon, 14 Mar 2022 12:08:05 +0000 Received: from mail-ej1-x635.google.com ([2a00:1450:4864:20::635]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1nTjUY-0000fq-HG for pgsql-admin@lists.postgresql.org; Mon, 14 Mar 2022 12:08:04 +0000 Received: by mail-ej1-x635.google.com with SMTP id qx21so33319883ejb.13 for ; Mon, 14 Mar 2022 05:08:02 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20210112.gappssmtp.com; s=20210112; h=message-id:subject:from:to:cc:date:in-reply-to:references :user-agent:mime-version:content-transfer-encoding; bh=YWJisoO82aNoiwNpyQ0IMASCS4Itz78XlzM8KefHix4=; b=ZK3EfNVwwyo8YvaTF0I9xG+Yy4WBLBkbOczf5xn3n2QL5NB6UEuXMiBrLSyDvrRzK1 kzeQUdH3ZapZraaaboQJYoQHNQ3e3yT+Wz6e5AgyYKz8grWh/KYcdGbWmAJB2QnLmpMF goBC0gUXg8vai8Ckp3gxh4TfI3UArNd6w6pTxaF6ri+kROYgUpM2Fg67UwPuc0nyrfGp G8jxOkLj0wVSVWdrBAyYG4iW549SuyvERmKaQ63yrcsOCkgAircpfhm/CXLXiC2S6Lwq FGwEfuoVoJGnW6XpQVsBp1VP5+drm0IcR/ybuOJflUkEdpCqYWTc5ATHXoRPfinwYBJl I8FQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:message-id:subject:from:to:cc:date:in-reply-to :references:user-agent:mime-version:content-transfer-encoding; bh=YWJisoO82aNoiwNpyQ0IMASCS4Itz78XlzM8KefHix4=; b=Zzga6de2Xh73YyMBp0TPFofiCusGGuFTl2pWHfufRYeZlDzVaNoo84ZpGoa+Jx9TWn f+94vBAseZ5RqHUMKPgvISsLDM1CErJYnBMt2t/kr+3Us7VL667b3gU6lJKCcHBJrTfu c4upQCRJkRo1z8AxsXXjRPoT4s6I4yYMHbI7JE/OWHFxCzqfk5yR4mpbEZvMvgXlN6QU h0ZGiTm6hgkOIstAJx63hzglLVN7laFA6PwgkIMBnT+i/dhM3mUyRAIXSz69oO0A+Dhu jlY+zCPmpwptD4rcJ+uO8tW8GPjOD5vmN4dVZo9CuWdRFO3fTP9PBcT+BmZ8CSuu+z5h Qibw== X-Gm-Message-State: AOAM530s01z5QE2firYV0R5AtmwZx8LE1ZQbfdQdo07p25PQLQyw5lHZ y85kJ+CjHBkaKtZKHCekSZ01kg== X-Google-Smtp-Source: ABdhPJxO8751bKb7qWmpu+EXMtAv1lAFCc63ciS0pUWfHG4faX9nDCrXHdgBD+dqVoUpBQn9SLXVog== X-Received: by 2002:a17:907:a424:b0:6db:b16:1e41 with SMTP id sg36-20020a170907a42400b006db0b161e41mr19580553ejc.458.1647259677826; Mon, 14 Mar 2022 05:07:57 -0700 (PDT) Received: from localhost.localdomain ([2001:871:5e:6a5b:96e0:9daf:2754:3959]) by smtp.gmail.com with ESMTPSA id e8-20020a17090681c800b006d9f7b69649sm6653036ejx.32.2022.03.14.05.07.56 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Mon, 14 Mar 2022 05:07:57 -0700 (PDT) Message-ID: <7573b9d64872074faf2490da947aa5f81edba880.camel@cybertec.at> Subject: Re: PostgreSQL Installation From: Laurenz Albe To: Nikhil Shetty Cc: edi mari , Pgsql-admin Date: Mon, 14 Mar 2022 13:07:56 +0100 In-Reply-To: References: <8aefabdcee722979c2b01ef103e2835b2e27629e.camel@cybertec.at> Content-Type: text/plain; charset="UTF-8" User-Agent: Evolution 3.40.4 (3.40.4-3.fc34) MIME-Version: 1.0 Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Mon, 2022-03-14 at 11:50 +0530, Nikhil Shetty wrote: > Just curious, Is there any technical advantage to having additional file systems for "pg_wal" and the log files.? 1. avoid log files and data files from filling your WAL disk and crashing the server 2. if you are using different devices, spread the I/O load Yours, Laurenz Albe -- Cybertec | https://www.cybertec-postgresql.com