Disable WAL completely - Mailing list pgsql-performance

From Kathirvel, Jeevanandam
Subject Disable WAL completely
Date
Msg-id EB493C98A0338748AA3D997E071B0574601DA4@IE10EV813.global.ds.honeywell.com
Whole thread Raw
Responses Re: Disable WAL completely
Re: Disable WAL completely
List pgsql-performance

Hi,

            I want to disable Write Ahead Log (WAL) completely because of following reasons,

 

  1. I am running Linux on the Compact Flash, which has limited memory; I can’t afford disk space of 32MB for pg_xlog folder. ( checkpoints_segments = 1)

 

  1. CF has own limitation with respect to number of writes (I/O operation).

 

  1. And, Our Database is Small and embedded as part of system (along with web-server, drivers). We may not require data recovery from the pg_xlog folder. It is not an enterprise application.

 

Please give your inputs, to resolve this issue..

 

Thanks,

Jeeva…

pgsql-performance by date:

Previous
From: Peter Schuller
Date:
Subject: Re: shared_buffers in 8.3 w/ lots of RAM on dedicated PG machine
Next
From: hubert depesz lubaczewski
Date:
Subject: Re: Disable WAL completely