The following bug has been logged on the website:
Bug reference: 9161
Logged by: Clemens Eisserer
Email address: linuxhippy@gmail.com
PostgreSQL version: 9.2.6
Operating system: Linux
Description:
It seems wal_writer_delay is limited to 10s without any technical reason.
I am using postgresql in an embedded system and writing every 10s
burns flash at an amazing rate (a 32GB SDHC card survived 4 days with
only a few GB written) - I've now switched from ext4 to nilfs2 which is able
to distribute writes more evenly - but I am still not confident this setup
would last longer than a few weeks/months.
A wal_writer_delay of arround ~1h would be a lot more efficient and solve
this issue.