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
regards, tom lane
In response to
pgsql-general by date
|Next:||From: Paul Thomas||Date: 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 Lane||Date: 2004-05-29 04:37:11|
|Subject: Re: Use composite type for column data type |