Re: Disable WAL completely - Mailing list pgsql-performance

From hubert depesz lubaczewski
Subject Re: Disable WAL completely
Date
Msg-id 20080218093240.GA8568@depesz.com
Whole thread Raw
In response to Re: Disable WAL completely  ("Kathirvel, Jeevanandam" <Jeevanandam.Kathirvel@honeywell.com>)
Responses Re: Disable WAL completely
List pgsql-performance
On Mon, Feb 18, 2008 at 03:00:47PM +0530, Kathirvel, Jeevanandam wrote:
>     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?

it will, but in case you'll lost power you will also (most probably)
loose your database.

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: "Kathirvel, Jeevanandam"
Date:
Subject: Re: Disable WAL completely
Next
From: "Nikolas Everett"
Date:
Subject: Controling where temporary files are created