Re: PostgreSQL 9.0.4 blocking in lseek?

From: Claudio Freire <klaussfreire(at)gmail(dot)com>
To: Gregg Jaskiewicz <gryzman(at)gmail(dot)com>
Cc: Sören Meyer-Eppler <soerenme(at)google(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: PostgreSQL 9.0.4 blocking in lseek?
Date: 2011-10-27 14:54:57
Message-ID: CAGTBQpY2=mThnqVowkjWcTBaj6at_oUcGqYPMy6tzzBwLGJE5Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Thu, Oct 27, 2011 at 4:42 AM, Gregg Jaskiewicz <gryzman(at)gmail(dot)com> wrote:
> What does 'select * from pg_stat_activity' say, more precisely - the
> "waiting" column.

Whether that particular process is waiting for it to be granted some
kind of database-level lock.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Samuel Gendler 2011-10-27 16:47:15 backups blocking everything
Previous Message Sören Meyer-Eppler 2011-10-27 12:03:46 Re: PostgreSQL 9.0.4 blocking in lseek?