Re: turn WAL off. - Mailing list pgsql-general

From Alexander Cohen
Subject Re: turn WAL off.
Date
Msg-id 0AADA570-B10F-11D8-9135-000A95B947DC@toomuchspace.com
Whole thread Raw
In response to Re: turn WAL off.  (Martijn van Oosterhout <kleptog@svana.org>)
Responses Re: turn WAL off.  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
> On Fri, May 28, 2004 at 04:54:36PM -0400, Alexander Cohen wrote:
>> Is it possible to turn WAL completely off. For good reasons, i dont
>> ever want to use it. How can i turn it off?
>
> You can't. The postgresql team is not in the business of producing
> databases that can't handle a power failure.
>
> Any hints as to what your "good reason" is?

I need a small cluster. Thats the main reason. 30 Mb with no data in it
is pretty large, to me at least. And im not using it in a manner that a
power failure will matter. It used to be possible before 7.1 right? At
least thats what it seems to say. It says something like "... since
7.1, WAL is turned on automatically..."

Alex


pgsql-general by date:

Previous
From: Doug McNaught
Date:
Subject: Re: Dump 7.1.3->7.4.2
Next
From: Tom Lane
Date:
Subject: Re: Use composite type for column data type