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

Re: turn WAL off.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Alexander Cohen <alex(at)toomuchspace(dot)com>
Cc: Martijn van Oosterhout <kleptog(at)svana(dot)org>,pgsql-general(at)postgresql(dot)org
Subject: Re: turn WAL off.
Date: 2004-05-29 05:17:57
Message-ID: 15165.1085807877@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-general
Alexander Cohen <alex(at)toomuchspace(dot)com> writes:
>>> 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.

To be blunt, you don't want Postgres.  Consider Berkeley DB or tinysql
or (holds nose) MySQL.  What you're after isn't within the design goals
for this project, either as to disk footprint or disinterest in power
failure behavior.

			regards, tom lane

In response to

Responses

pgsql-general by date

Next:From: Paul ThomasDate: 2004-05-29 08:58:56
Subject: Re: PostgreSQL delete the blank in the end of the String automatically. how can I avoid it?
Previous:From: Tom LaneDate: 2004-05-29 04:37:11
Subject: Re: Use composite type for column data type

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