Re: Postgresql Database and PG_WAL locations

From: Ron Johnson <ronljohnsonjr(at)gmail(dot)com>
To: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: Postgresql Database and PG_WAL locations
Date: 2024-08-29 19:02:54
Message-ID: CANzqJaBPFm5wjGRuzC8Ywh1=uaeg4BRunhFGgruoy1e-ZxR2Cw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Thu, Aug 29, 2024 at 2:22 PM Matthew Tice <mjtice(at)gmail(dot)com> wrote:

> On Aug 29, 2024, at 12:18 PM, Henry Ashu <henry(dot)ashu(at)dat(dot)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.

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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Matthew Tice 2024-08-29 19:11:57 Re: Postgresql Database and PG_WAL locations
Previous Message Ron Johnson 2024-08-29 18:58:53 Re: Postgresql Software Location