Обсуждение: Totally Disable writing to xlog file

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 ?

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.