On Thu, 2024-08-29 at 15:02 -0400, Ron Johnson wrote:
> 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?.
> >
> >
> > 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
