Re: Identifying the nature of blocking I/O - Mailing list pgsql-performance

From Tom Lane
Subject Re: Identifying the nature of blocking I/O
Date
Msg-id 866.1219628227@sss.pgh.pa.us
Whole thread Raw
In response to Re: Identifying the nature of blocking I/O  (Craig Ringer <craig@postnewspapers.com.au>)
Responses Re: Identifying the nature of blocking I/O  (Greg Smith <gsmith@gregsmith.com>)
List pgsql-performance
Craig Ringer <craig@postnewspapers.com.au> writes:
> Peter Schuller wrote:
>> But in general, it would be very interesting to see, at any given
>> moment, what PostgreSQL backends are actually blocking on from the
>> perspective of PostgreSQL.

> The recent work on DTrace support for PostgreSQL will probably give you
> the easiest path to useful results. You'll probably need an OpenSolaris
> or (I think) FreeBSD host, though, rather than a Linux host.

<cant-resist>get a mac</cant-resist>

(Mind you, I don't think Apple sells any hardware that would be really
suitable for a big-ass database server.  But for development purposes,
OS X on a recent laptop is a pretty nice unix-at-the-core-plus-eye-candy
environment.)

            regards, tom lane

pgsql-performance by date:

Previous
From: "Scott Carey"
Date:
Subject: Re: Identifying the nature of blocking I/O
Next
From: Tom Lane
Date:
Subject: Re: Identifying the nature of blocking I/O