Re: PG slowdown - Mailing list pgsql-admin

From Joshua D. Drake
Subject Re: PG slowdown
Date
Msg-id 44B5C30E.3020604@commandprompt.com
Whole thread Raw
In response to Re: PG slowdown  (adey <adey11@gmail.com>)
List pgsql-admin
adey wrote:
> If you turn WAL logging off (via fsynch parameter in .conf), it is my
> understanding that you will no longer log database updates, and will
> therefore not be able to recover any uncommitted transactions in the
> event of failure, (which seems contradictory to database practice).
>

You can not turn of WAL logging. You can only delay how the data is
written to disk.

Sincerely,

Joshua D. Drake



--

    === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
    Providing the most comprehensive  PostgreSQL solutions since 1997
              http://www.commandprompt.com/



pgsql-admin by date:

Previous
From: adey
Date:
Subject: Re: PG slowdown
Next
From: adey
Date:
Subject: Where are the temporary work / sort files please