Re: wal-debug

From: "Munteanu Gabriel" <gmunteanu(at)rdslink(dot)ro>
To: "Martijn van Oosterhout" <kleptog(at)svana(dot)org>
Cc: "postgres-general" <pgsql-general(at)postgresql(dot)org>
Subject: Re: wal-debug
Date: 2003-03-03 22:36:21
Message-ID: 010601c2e1d5$50cc5fd0$4b5ae73e@SERVERXP
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

ok, Thanx
----- Original Message -----
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>
Sent: Monday, March 03, 2003 4:00 PM
Subject: Re: [GENERAL] wal-debug

[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.
--

In response to

  • Re: wal-debug at 2003-03-04 00:00:36 from Martijn van Oosterhout

Browse pgsql-general by date

  From Date Subject
Next Message Patrick Bye (WFF) 2003-03-03 22:38:33 Help with functions (Never mind)
Previous Message Martijn van Oosterhout 2003-03-03 22:28:39 Re: wal-debug