Re: turn WAL off.

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