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