Re: BUG #9161: wal_writer_delay is limited to 10s - Mailing list pgsql-bugs

From Clemens Eisserer
Subject Re: BUG #9161: wal_writer_delay is limited to 10s
Date
Msg-id CAFvQSYRrVETD5kQ_ga=cS33VSu5+9jpvc43KasSjgRKsR6G61Q@mail.gmail.com
Whole thread Raw
In response to Re: BUG #9161: wal_writer_delay is limited to 10s  (Andres Freund <andres@2ndquadrant.com>)
Responses Re: BUG #9161: wal_writer_delay is limited to 10s  (Andres Freund <andres@2ndquadrant.com>)
List pgsql-bugs
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

pgsql-bugs by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Bad behaviour on some geometric operations on degenerate polygons
Next
From: Andres Freund
Date:
Subject: Re: BUG #9161: wal_writer_delay is limited to 10s