On Thu, 2024-08-29 at 15:02 -0400, Ron Johnson wrote: > On Thu, Aug 29, 2024 at 2:22 PM Matthew Tice <mjtice@xxxxxxxxx> wrote: > > > On Aug 29, 2024, at 12:18 PM, Henry Ashu <henry.ashu@xxxxxxx> 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
