public inbox for [email protected]  

help / color / mirror / Atom feed

From: Matthew Tice <[email protected]>
Cc: Pgsql-admin <[email protected]>
Subject: Re: Postgresql Database and PG_WAL locations
Date: Thu, 29 Aug 2024 13:11:57 -0600
Message-ID: <[email protected]> (raw)
In-Reply-To: <CANzqJaBPFm5wjGRuzC8Ywh1=uaeg4BRunhFGgruoy1e-ZxR2Cw@mail.gmail.com>
References: <CABHPps4uW9RFwUc0_2CoPMZ1_Du8HRuvNwyXRvCp48ZzgUuKzQ@mail.gmail.com>
	<[email protected]>
	<CANzqJaBPFm5wjGRuzC8Ywh1=uaeg4BRunhFGgruoy1e-ZxR2Cw@mail.gmail.com>



> On Aug 29, 2024, at 1:02 PM, Ron Johnson <[email protected]> wrote:
> 
> On Thu, Aug 29, 2024 at 2:22 PM Matthew Tice <[email protected] <mailto:[email protected]>> wrote:
>>> On Aug 29, 2024, at 12:18 PM, Henry Ashu <[email protected] <mailto:[email protected]>> 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?.
>>> 
>> 
>> Take a look at https://wiki.postgresql.org/wiki/Installation_and_Administration_Best_practices
>> 
>> 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.

Good point.  I didn’t even notice that disclaimer at the top "Seek knowledge elsewhere, as the material in here predates Postgres 9 it seems.”…

But regarding the wal/data separation, I still think it’s 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).

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

view thread (8+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: Postgresql Database and PG_WAL locations
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox