| From: | linuxhippy(at)gmail(dot)com |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | BUG #9161: wal_writer_delay is limited to 10s |
| Date: | 2014-02-09 12:24:04 |
| Message-ID: | 20140209122404.26449.49425@wrigleys.postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 9161
Logged by: Clemens Eisserer
Email address: linuxhippy(at)gmail(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2014-02-09 17:14:06 | Re: BUG #9161: wal_writer_delay is limited to 10s |
| Previous Message | Tom Lane | 2014-02-08 20:25:11 | Re: BUG #9148: generate invalid index (create index CONCURRENTLY ... ) |