public inbox for [email protected]  

help / color / mirror / Atom feed

From: Laurenz Albe <[email protected]>
To: Ron Johnson <[email protected]>
To: Pgsql-admin <[email protected]>
Subject: Re: Postgresql Database and PG_WAL locations
Date: Mon, 02 Sep 2024 12:30:32 +0200
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 Thu, 2024-08-29 at 15:02 -0400, Ron Johnson wrote:
> On Thu, Aug 29, 2024 at 2:22 PM Matthew Tice <[email protected]> wrote:
> > > On Aug 29, 2024, at 12:18 PM, Henry Ashu <[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.

I think the advice is still valid.

Today you'd have different filesystems on different logical volumes rather
than different physical disks, but it is still a good idea to separate data and WAL,
so that they cannot fill up each other's file system.

I'd actually define a third file system for the PostgreSQL log files, for
the same reason.

Yours,
Laurenz Albe

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], [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