From: | "Kathirvel, Jeevanandam" <Jeevanandam(dot)Kathirvel(at)honeywell(dot)com> |
---|---|
To: | <pgsql-performance(at)postgresql(dot)org> |
Subject: | Disable WAL completely |
Date: | 2008-02-18 09:11:50 |
Message-ID: | EB493C98A0338748AA3D997E071B0574601DA4@IE10EV813.global.ds.honeywell.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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)
2. CF has own limitation with respect to number of writes (I/O
operation).
3. 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...
From | Date | Subject | |
---|---|---|---|
Next Message | hubert depesz lubaczewski | 2008-02-18 09:19:40 | Re: Disable WAL completely |
Previous Message | Peter Schuller | 2008-02-18 07:39:46 | Re: shared_buffers in 8.3 w/ lots of RAM on dedicated PG machine |