Tuning question: WAL disk speed - Mailing list pgsql-general

From Jonathan Ellis
Subject Tuning question: WAL disk speed
Date
Msg-id 3EF52BD8.50205@carnageblender.com
Whole thread Raw
List pgsql-general
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


pgsql-general by date:

Previous
From: Mark Wilson
Date:
Subject: Re: Foreign Key can't refer to one of 2 primary keys
Next
From: Bruce Momjian
Date:
Subject: Re: A creepy story about dates. How to prevent it?