[prev in list] [next in list] [prev in thread] [next in thread] 

List:       pgsql-performance
Subject:    Re: [PERFORM] set autovacuum=off
From:       Robert Haas <robertmhaas () gmail ! com>
Date:       2012-03-21 14:32:26
Message-ID: CA+TgmoZTKY+MpD6tXHOYN5QMagcNJsR_DBJ+fWPqU-voDrkb=Q () mail ! gmail ! com
[Download RAW message or body]

On Thu, Feb 23, 2012 at 3:28 PM, Alessandro Gagliardi
<alessandro@path.com> wrote:
> I'm unable to make sense of pg_locks. The vast majority are
> locktype='transactionid', mode='ExclusiveLock', granted=t. There are some
> 'relation' locks with mode='RowExclusiveLock' and fewer with
> 'AccessShareLock'. I have no idea what I should be looking for here.

If you have lock contention, you'll see locks with granted='f', at
least from time to time.  Those are the ones you want to worry about.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
[prev in list] [next in list] [prev in thread] [next in thread]