Skip site navigation (1) Skip section navigation (2)

Re: Identifying the nature of blocking I/O

From: Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
To: Peter Schuller <peter(dot)schuller(at)infidyne(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Identifying the nature of blocking I/O
Date: 2008-08-25 00:30:18
Message-ID: 48B1FD1A.7040807@postnewspapers.com.au (view raw or flat)
Thread:
Lists: pgsql-performance
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

In response to

Responses

pgsql-performance by date

Next:From: Scott CareyDate: 2008-08-25 01:08:08
Subject: Re: Large number of tables slow insert
Previous:From: Loic PetitDate: 2008-08-24 22:30:44
Subject: Re: Large number of tables slow insert

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group