Re: wal-debug

From: Martijn van Oosterhout <kleptog(at)svana(dot)org>
To: Munteanu Gabriel <gmunteanu(at)rdslink(dot)ro>
Cc: postgres-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: wal-debug
Date: 2003-03-04 00:00:36
Message-ID: 20030304000036.GD31057@svana.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dennis Gearon 2003-03-04 00:02:59 Re: almost there on a design
Previous Message Richard Welty 2003-03-03 23:23:51 Re: Q from new user about postgresql?