[PERFORM] Disable WAL completely

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 r

Re: [PERFORM] Disable WAL completely

] Sent: Monday, February 18, 2008 2:50 PM To: Kathirvel, Jeevanandam Cc: pgsql-performance@postgresql.org Subject: Re: [PERFORM] Disable WAL completely On Mon, Feb 18, 2008 at 02:41:50PM +0530, Kathirvel, Jeevanandam wrote: > I want to disable Write Ahead Log (WAL) completely beca

[PERFORM] Inact_dirty is increasing continuously and causing the system to hang.

Hi, We are seeing system hang-up issue when we do continuous update on table ( 2-3 records/sec) within 10-12 hours. Memory parameter Inact_dirty( shown in /proc/meminfo) is increasing continuously and causing the system to hang-up(not responding state). This issue is not happening when