Re: wal-debug - Mailing list pgsql-general

From Munteanu Gabriel
Subject Re: wal-debug
Date
Msg-id 010601c2e1d5$50cc5fd0$4b5ae73e@SERVERXP
Whole thread Raw
In response to wal-debug  ("Munteanu Gabriel" <gmunteanu@rdslink.ro>)
List pgsql-general
ok, Thanx
----- Original Message -----
From: "Martijn van Oosterhout" <kleptog@svana.org>
To: "Munteanu Gabriel" <gmunteanu@rdslink.ro>
Cc: "postgres-general" <pgsql-general@postgresql.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.
--


pgsql-general by date:

Previous
From: Dennis Gearon
Date:
Subject: Re: almost there on a design
Next
From: Stephan Szabo
Date:
Subject: Re: almost there on a design