Skip site navigation (1) Skip section navigation (2)

Re: turn WAL off.

From: Alexander Cohen <alex(at)toomuchspace(dot)com>
To: Martijn van Oosterhout <kleptog(at)svana(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: turn WAL off.
Date: 2004-05-29 01:25:16
Message-ID: 0AADA570-B10F-11D8-9135-000A95B947DC@toomuchspace.com (view raw or flat)
Thread:
Lists: 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


In response to

Responses

pgsql-general by date

Next:From: Tom LaneDate: 2004-05-29 04:37:11
Subject: Re: Use composite type for column data type
Previous:From: Doug McNaughtDate: 2004-05-29 00:02:12
Subject: Re: Dump 7.1.3->7.4.2

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group