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: | Whole Thread | Raw Message | 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!
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 |