| 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: | Whole Thread | Raw Message | 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 |