From: Matthew Tice <mjtice@gmail.com>
Content-Type: multipart/alternative;
	boundary="Apple-Mail=_5E73866C-C0D1-4703-A88C-4BC6EE61717B"
Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3776.700.51\))
Subject: Re: Postgresql Database and PG_WAL locations
Date: Thu, 29 Aug 2024 13:11:57 -0600
In-Reply-To: 
 <CANzqJaBPFm5wjGRuzC8Ywh1=uaeg4BRunhFGgruoy1e-ZxR2Cw@mail.gmail.com>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
References: 
 <CABHPps4uW9RFwUc0_2CoPMZ1_Du8HRuvNwyXRvCp48ZzgUuKzQ@mail.gmail.com>
 <5BDE97CE-242C-479A-BDC7-CF263BBD554B@gmail.com>
 <CANzqJaBPFm5wjGRuzC8Ywh1=uaeg4BRunhFGgruoy1e-ZxR2Cw@mail.gmail.com>
Message-Id: <D015437F-B9E5-4136-9F34-18BFD2BAA764@gmail.com>
Archived-At: 
 <https://www.postgresql.org/message-id/D015437F-B9E5-4136-9F34-18BFD2BAA764%40gmail.com>
Precedence: bulk


--Apple-Mail=_5E73866C-C0D1-4703-A88C-4BC6EE61717B
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain;
	charset=utf-8


> On Aug 29, 2024, at 1:02=E2=80=AFPM, Ron Johnson =
<ronljohnsonjr@gmail.com> wrote:
>=20
> On Thu, Aug 29, 2024 at 2:22=E2=80=AFPM Matthew Tice <mjtice@gmail.com =
<mailto:mjtice@gmail.com>> wrote:
>>> On Aug 29, 2024, at 12:18=E2=80=AFPM, Henry Ashu <henry.ashu@dat.com =
<mailto:henry.ashu@dat.com>> wrote:
>>>=20
>>> I have a database that's about 2TB in size, and I want to place the =
database files in a separate mount point(PGDATA) and the log files in a =
different mount point(PG_WAL). What's your take on this?.
>>>=20
>>=20
>> Take a look at =
https://wiki.postgresql.org/wiki/Installation_and_Administration_Best_prac=
tices
>>=20
>> Essentially, yes, you will want your WAL and data stored on different =
devices (or the very least, different partitions).
>=20
>=20
> Is that recommendation still valid?  After all, that was written when =
15 years old Sun Studio 12 was still pertinent.  Times have changed =
since then.  Disks are much, much bigger.

Good point.  I didn=E2=80=99t even notice that disclaimer at the top =
"Seek knowledge elsewhere, as the material in here predates Postgres 9 =
it seems.=E2=80=9D=E2=80=A6

But regarding the wal/data separation, I still think it=E2=80=99s =
relevant (isolating the IO between data files and wal).  But I guess =
like anything else it depends on your workload (and, in this case, your =
storage subsystem capabilities).

>=20
> --
> Death to America, and butter sauce.
> Iraq lobster!


--Apple-Mail=_5E73866C-C0D1-4703-A88C-4BC6EE61717B
Content-Transfer-Encoding: quoted-printable
Content-Type: text/html;
	charset=utf-8

<html><head><meta http-equiv=3D"content-type" content=3D"text/html; =
charset=3Dutf-8"></head><body style=3D"overflow-wrap: break-word; =
-webkit-nbsp-mode: space; line-break: after-white-space;"><meta =
http-equiv=3D"content-type" content=3D"text/html; charset=3Dutf-8"><div =
style=3D"overflow-wrap: break-word; -webkit-nbsp-mode: space; =
line-break: after-white-space;"><br =
id=3D"lineBreakAtBeginningOfMessage"><div><br><blockquote =
type=3D"cite"><div>On Aug 29, 2024, at 1:02=E2=80=AFPM, Ron Johnson =
&lt;ronljohnsonjr@gmail.com&gt; wrote:</div><br =
class=3D"Apple-interchange-newline"><div><div dir=3D"ltr"><div =
dir=3D"ltr">On Thu, Aug 29, 2024 at 2:22=E2=80=AFPM Matthew Tice &lt;<a =
href=3D"mailto:mjtice@gmail.com">mjtice@gmail.com</a>&gt; =
wrote:</div><div class=3D"gmail_quote"><blockquote class=3D"gmail_quote" =
style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid =
rgb(204,204,204);padding-left:1ex"><div><div><blockquote =
type=3D"cite"><div>On Aug 29, 2024, at 12:18=E2=80=AFPM, Henry Ashu =
&lt;<a href=3D"mailto:henry.ashu@dat.com" =
target=3D"_blank">henry.ashu@dat.com</a>&gt; wrote:</div><br><div><div =
dir=3D"ltr">I have a database that's about 2TB in size, and I want to =
place the database files in a separate&nbsp;mount point(PGDATA) and the =
log files in a different mount point(PG_WAL). What's your take&nbsp;on =
this?.<br clear=3D"all"><div><div dir=3D"ltr" =
class=3D"gmail_signature"><div dir=3D"ltr"><div style=3D"font-family: =
Gotham, &quot;Helvetica Neue&quot;, Helvetica, Arial, sans-serif; =
font-size: 0.8rem; line-height: 1.2rem;"><br =
class=3D"webkit-block-placeholder"></div></div></div></div></div></div></b=
lockquote><div><br></div><div>Take a look at&nbsp;<a =
href=3D"https://wiki.postgresql.org/wiki/Installation_and_Administration_B=
est_practices" =
target=3D"_blank">https://wiki.postgresql.org/wiki/Installation_and_Admini=
stration_Best_practices</a></div><div><br></div><div>Essentially, yes, =
you will want your WAL and data stored on different devices (or the very =
least, different =
partitions).</div></div></div></blockquote></div><div><br></div><div>Is =
that recommendation&nbsp;still valid?&nbsp; After all, that was written =
when&nbsp;<b>15 years old</b>&nbsp;Sun Studio 12 was still =
pertinent.&nbsp; Times have changed since then.&nbsp; Disks are much, =
<i>much</i> =
bigger.</div></div></div></blockquote><div><br></div><div>Good point. =
&nbsp;I didn=E2=80=99t even notice that disclaimer at the top "<span =
style=3D"background-color: rgb(255, 255, 255);"><font =
face=3D"sans-serif"><span style=3D"font-size: 12.7px;">Seek knowledge =
elsewhere, as the material in here predates Postgres 9 it =
seems.=E2=80=9D</span></font></span><font face=3D"sans-serif"><span =
style=3D"font-size: 12.7px;">=E2=80=A6</span></font></div><div><span =
style=3D"background-color: rgb(255, 255, 255);"><font =
face=3D"sans-serif"><span style=3D"font-size: =
12.7px;"><br></span></font></span>But regarding the wal/data separation, =
I still think it=E2=80=99s relevant (isolating the IO between data files =
and wal). &nbsp;But I guess like anything else it depends on your =
workload (and, in this case, your storage subsystem =
capabilities).</div></div><div><br><blockquote type=3D"cite"><div><div =
dir=3D"ltr"><div><br></div><span class=3D"gmail_signature_prefix">-- =
</span><br><div dir=3D"ltr" class=3D"gmail_signature"><div =
dir=3D"ltr">Death to America, and butter sauce.<div>Iraq =
lobster!</div></div></div></div>
</div></blockquote></div><br></div></body></html>=

--Apple-Mail=_5E73866C-C0D1-4703-A88C-4BC6EE61717B--