Re: Totally Disable writing to xlog file

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: chandra sekhar <sekhar(dot)career(at)gmail(dot)com>
Cc: "pgsql-www(at)postgresql(dot)org" <pgsql-www(at)postgresql(dot)org>
Subject: Re: Totally Disable writing to xlog file
Date: 2017-12-02 17:47:24
Message-ID: CAKFQuwaKcZC3C2Qmaj_cOLBS8=54+GSVFom4D9hbaxHRyymC5Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-www

On Saturday, December 2, 2017, chandra sekhar <sekhar(dot)career(at)gmail(dot)com>
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.

In response to

Browse pgsql-www by date

  From Date Subject
Next Message Pavel Golub 2017-12-03 16:16:33 Re: [pgsql-www] Wiki editor request
Previous Message chandra sekhar 2017-12-02 17:12:28 Totally Disable writing to xlog file