Re: Discourage splitting pg_wal directory

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(dot)albe(at)cybertec(dot)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