Re: Discourage splitting pg_wal directory

2024-03-19 Thread Laurenz Albe
On Tue, 2024-03-19 at 11:04 -0400, Greg Sabino Mullane wrote: > On Mon, Mar 18, 2024 at 11:58 AM Laurenz Albe > 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 disk

Re: Discourage splitting pg_wal directory

2024-03-19 Thread Greg Sabino Mullane
On Mon, Mar 18, 2024 at 11:58 AM Laurenz Albe 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 sa

Re: Discourage splitting pg_wal directory

2024-03-18 Thread Laurenz Albe
On Mon, 2024-03-18 at 11:32 -0400, Greg Sabino Mullane wrote: > "It is advantageous if the WAL is located on a different disk from the > main database files. This can be achieved by moving the pg_wal directory > to another location (while the server is shut down, of course) and > creating a symboli

Discourage splitting pg_wal directory

2024-03-18 Thread Greg Sabino Mullane
Someone pointed out this morning that we still have this in our docs: "It is advantageous if the WAL is located on a different disk from the main database files. This can be achieved by moving the pg_wal directory to another location (while the server is shut down, of course) and creating a symbol