Re: Disable WAL completely

From: hubert depesz lubaczewski <depesz(at)depesz(dot)com>
To: "Kathirvel, Jeevanandam" <Jeevanandam(dot)Kathirvel(at)honeywell(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Disable WAL completely
Date: 2008-02-18 09:32:40
Message-ID: 20080218093240.GA8568@depesz.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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)

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Nikolas Everett 2008-02-18 15:27:39 Controling where temporary files are created
Previous Message Kathirvel, Jeevanandam 2008-02-18 09:30:47 Re: Disable WAL completely