Postgres Pro
Downloads
Home   >   mailing lists

Thread: Totally Disable writing to xlog file

Totally Disable writing to xlog file

From
chandra sekhar
Date:
Hello Gurus, Is it possible to disable writing to WAL completely. 1) Is the setting WalLevel = Minimal , completely disables writing to WAL ? 2) Is the walLevel setting is at instance level or database level ? 3) is postgres creates 1 Log file for each database in a cluster ?

Re: Totally Disable writing to xlog file

From
"David G. Johnston"
Date:
On Saturday, December 2, 2017, chandra sekhar wrote: > Hello Gurus, > > Is it possible to disable writing to WAL completely. > > 1) Is the setting WalLevel = Minimal , completely disables writing to WAL ? > 2) Is the walLevel setting is at instance level or database level ? > 3) is postgres creates 1 Log file for each database in a cluster ? > > No, WAL is fundamental to the operation of the software. You get one WAL stream per cluster. David J.