On 04/28/2014 09:07 PM, Karl Denninger wrote:
The WAL is fsync'd frequently. My guess is that that causes a lot of
extra work to repeatedly recompress the same data, or something like
that.
It shouldn't as ZFS re-writes on change, and what's showing up is not
high I/O*count* but rather percentage-busy, which implies lots of head
movement (that is, lots of sub-allocation unit writes.)
That sounds consistent frequent fsyncs.
Isn't WAL essentially sequential writes during normal operation?
Yes, it's totally sequential. But it's fsync'd at every commit, which
means a lot of small writes.
- Heikki
--
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance