Re: wal-debug

On Mon, Mar 03, 2003 at 01:46:39PM -0800, Munteanu Gabriel wrote:
> in the URL you sent me, i read the following:
> Write Ahead Logging (WAL) is a standard approach to transaction logging. Its
> detailed description may be found in most (if not all) books about
> transaction processing. Briefly, WAL's central concept is that changes to

[snip]

Well, it can disperse the writes so they are spread more efficiently, but yes
it can be more writes.

> I am not doing something specially, I want to increase performance, that's
> all.
>
> and wanted to disable WAL.

Well, you can't disable WAL. But since you don't mind the stability of your
data you could just get an older version (pre-WAL) say 7.0 or 7.1.

You can also turn off fsync. Then it might disappear from your disk cache
instead of being written. Either way you're putting your data at risk.
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> Support bacteria! They're the only culture some people have.