Skip site navigation (1) Skip section navigation (2)

Re: turn WAL off.

From: Marty Scholes <marty(at)outputservices(dot)com>
To: pgsql-general(at)postgresql(dot)org, tgl(at)ss(dot)pgh(dot)pa(dot)us,alex(at)toomuchspace(dot)com
Cc: Marty Scholes <marty(at)outputservices(dot)com>
Subject: Re: turn WAL off.
Date: 2004-05-29 23:31:42
Message-ID: 40B91D5E.9070705@outputservices.com (view raw or flat)
Thread:
Lists: pgsql-general
tom lane writes:
 > To be blunt, you don't want Postgres.  Consider Berkeley DB or tinysql
 > or (holds nose) MySQL.  What you're after isn't
 > within the design goals for this project, either
 > as to disk footprint or disinterest in power
 > failure behavior.

Or, put the WAL files on a RAM disk (/tmp under Solaris, dunno for 
Linux).  Soft links would do the trick nicely.  Make sure that you 
understand that shutting down the machine, even cleanly, will likely 
destroy your Pg installation.

I have actually done this temporarily during emergency Oracle recovery, 
when it was important to minimuze reload time.  If the machine crashed 
during the reload, I didn't really lose that much.


pgsql-general by date

Next:From: Greg StarkDate: 2004-05-30 01:36:17
Subject: Re: Use arrays to store multilanguage texts
Previous:From: Karsten HilbertDate: 2004-05-29 22:10:42
Subject: Re: Use arrays to store multilanguage texts

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group