Postgres Pro
Downloads
Home   >   mailing lists

Re: Postgresql Database and PG_WAL locations - Mailing list pgsql-admin

From Ron Johnson
Subject Re: Postgresql Database and PG_WAL locations
Date
Msg-id CANzqJaBPFm5wjGRuzC8Ywh1=uaeg4BRunhFGgruoy1e-ZxR2Cw@mail.gmail.com
Whole thread Raw
In response to Re: Postgresql Database and PG_WAL locations  (Matthew Tice <mjtice@gmail.com>)
Responses Re: Postgresql Database and PG_WAL locations
Re: Postgresql Database and PG_WAL locations
Re: Postgresql Database and PG_WAL locations
List pgsql-admin
Tree view
On Thu, Aug 29, 2024 at 2:22 PM Matthew Tice <mjtice@gmail.com> wrote:
On Aug 29, 2024, at 12:18 PM, Henry Ashu <henry.ashu@dat.com> wrote:

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?.



Essentially, yes, you will want your WAL and data stored on different devices (or the very least, different partitions).

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.

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

pgsql-admin by date:

Previous
From: Ron Johnson
Date:
Subject: Re: Postgresql Software Location
Next
From: Matthew Tice
Date:
Subject: Re: Postgresql Database and PG_WAL locations