Re: Disable WAL completely - Mailing list pgsql-performance

From Kathirvel, Jeevanandam
Subject Re: Disable WAL completely
Date
Msg-id EB493C98A0338748AA3D997E071B0574601DED@IE10EV813.global.ds.honeywell.com
Whole thread Raw
In response to Re: Disable WAL completely  (hubert depesz lubaczewski <depesz@depesz.com>)
Responses Re: Disable WAL completely
List pgsql-performance
Hi Depesz,

    Is there way to minimize the I/O operation on disk/CF.

    Can I create RAM file system and point the pg_xlog files to RAM
location instead of CF.  whether this will work?

Regards,
Jeeva

-----Original Message-----
From: hubert depesz lubaczewski [mailto:depesz@depesz.com]
Sent: Monday, February 18, 2008 2:50 PM
To: Kathirvel, Jeevanandam
Cc: pgsql-performance@postgresql.org
Subject: Re: [PERFORM] Disable WAL completely

On Mon, Feb 18, 2008 at 02:41:50PM +0530, Kathirvel, Jeevanandam wrote:
>             I want to disable Write Ahead Log (WAL) completely because
> of following reasons,

basically, you can't disable it.

regards,

depesz

--
quicksil1er: "postgres is excellent, but like any DB it requires a
highly paid DBA.  here's my CV!" :)
http://www.depesz.com/ - blog dla ciebie (i moje CV)

pgsql-performance by date:

Previous
From: "A. Kretschmer"
Date:
Subject: Re: Disable WAL completely
Next
From: hubert depesz lubaczewski
Date:
Subject: Re: Disable WAL completely