Re: Re: disable wal - Mailing list pgsql-admin

From Anuradha Ratnaweera
Subject Re: Re: disable wal
Date
Msg-id Pine.LNX.4.21.0105020112210.533-100000@presario
Whole thread Raw
In response to Re: Re: disable wal  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Re: Re: disable wal
List pgsql-admin
I understand that that WAL is an integral part of 7.1 and "disabling" is
not possible. I also don't want to switch back to 7.0 becuse I _DO_ need
the new features.

If I don't care for reliability (for reasons I outlined earlier in this
thread), are there other parameters I can set to optimize for speed, such
as wal_sync_method? I already have turned off fsync and log_connections. I
can't turn on silent mode, because this machine is used for all testing
purposes and messages are useful.

Also, it is possible to avoid postgresql from trying to force the OS to
write data to the disk, so that WAL writes will be in disk cache for some
time?

Anuradha

On Mon, 30 Apr 2001, Tom Lane wrote:

> There is no way to "disable WAL".  However, you might try running with
> fsync turned off if you don't care about data integrity.
>
>             regards, tom lane
>


pgsql-admin by date:

Previous
From: Reiner Dassing
Date:
Subject: Re: Restoring a pg_dump fails with
Next
From: Tom Lane
Date:
Subject: Re: Restoring a pg_dump fails with