Re: Discourage splitting pg_wal directory - Mailing list pgsql-docs

From Laurenz Albe
Subject Re: Discourage splitting pg_wal directory
Date
Msg-id 67be0e7b3067a7db3a475e1c627bfdd79ab50846.camel@cybertec.at
Whole thread Raw
In response to Re: Discourage splitting pg_wal directory  (Greg Sabino Mullane <htamfids@gmail.com>)
List pgsql-docs
On Tue, 2024-03-19 at 11:04 -0400, Greg Sabino Mullane wrote:
> On Mon, Mar 18, 2024 at 11:58 AM Laurenz Albe <laurenz.albe@cybertec.at> wrote:
> > I think it is still a good idea to put data files and WAL on different file
> > systems.  Perhaps not so much with the intention of distributing I/O across
> > different disks, but to prevent the data files from filling the WAL disk.
>
> Cannot say I understand this - if the data files are crowding out the WAL,
> surely they are moments away from filling the disk on their own. Disk is cheap
> these days, so I'm not a fan of encouraging complexity if not needed.

If you run out of disk on the data files, you get an error and life goes on.

If WAL runs out of disk space, PostgreSQL will crash.

Yours,
Laurenz Albe



pgsql-docs by date:

Previous
From: Greg Sabino Mullane
Date:
Subject: Re: Discourage splitting pg_wal directory
Next
From: Erik Wienhold
Date:
Subject: Re: Monetary Data Types Improvement