Re: BUG #9161: wal_writer_delay is limited to 10s

Hi,

> The WAL writer shouldn't write anything if there's nothing to
> write. Maybe you have checkpoint_timeout set to something low and it's
> performing checkpoints regularly?

However, there is something to write - I perform a single insert
operation every 10s.
So what I would like to achieve is to have those inserts every 10s,
but a sync only every few minutes or so - to let the data written by
postgresql stay in the block cache.

> You might also rethink the quality of the media you're using...
> Indeed, from my experience, SD cards are terribly unreliable because
> they have terrible write leveling (if at all).

I already switched to a patched nilfs2 version, which makes even SD
cards happy with have horrible wear leveling - and I switched to
better cards.

However this is just my pet project, and all I ask is why a parameter
is artifically clipped ... it's not like I request some magical new
feature.

Regards, Clemens