Here are the values: # - Checkpoints -
checkpoint_segments = 256 # in logfile segments, min 1, 16MB each #checkpoint_timeout = 5min # range 30s-1h checkpoint_completion_target = 0.7 # checkpoint target duration, 0.0 - 1.0 #checkpoint_warning = 30s # 0 disables On Mon, Jul 29, 2013 at 5:06 PM, bricklen <brick...@gmail.com> wrote: > > On Mon, Jul 29, 2013 at 12:41 PM, German Becker > <german.bec...@gmail.com>wrote: > >> Luis, The disk only has the WAL (pg_xlog ) directory. Brett, Here are the >> mount options: >> >> /dev/sdb1 on /storage/sdb1 type ext3 >> (rw,noatime,data=writeback,errors=remount-ro) >> >> BTW The original fs was ext4, now I am trying with ext3, with the exact >> same results. No noticeable changes using diferent journal modes. >> >> I also tried disabling the journal altogether, which dramatically reduced >> the disk usage, but nevertheless there was this latency spikes. >> > > > I haven't been following this thread and might have missed it, but did you > show your checkpoint_completion_target? >
