Disable WAL completely

"Kathirvel, Jeevanandam" <Jeevanandam.Kathirvel@xxxxxxxxxxxxx> · Mon, 18 Feb 2008 14:41:50 +0530

Hi,

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

 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)

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

 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…