How can I tell if writing to the WAL is a bottleneck? In other words,
how can I tell if upgrading the disk the WAL is on will improve
performance? (I do have the WAL on its own disk.)
Semi-related question: does postgresql ever block while waiting for data
to be written to the main structures if the backlog of pending writes
gets big enough? My impression is no but as long as I'm mailing General
I thought I'd check on that one. :)
-Jonathan