Postgres Pro
Downloads
Home   >   mailing lists

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

From Craig Ringer
Subject Re: Identifying the nature of blocking I/O
Date
Msg-id 48B1FD1A.7040807@postnewspapers.com.au
Whole thread Raw
In response to Identifying the nature of blocking I/O  (Peter Schuller <peter.schuller@infidyne.com>)
Responses Re: Identifying the nature of blocking I/O  ("Scott Carey" <scott@richrelevance.com>)
Re: Identifying the nature of blocking I/O  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
Tree view 
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.

--
Craig Ringer

pgsql-performance by date:

Previous
From: "Loic Petit"
Date:
Subject: Re: Large number of tables slow insert
Next
From: "Scott Carey"
Date:
Subject: Re: Large number of tables slow insert