From: Alan Hodgson <ahodgson@simkin.ca>
Organization: Simkin Network Consulting
To: pgsql-performance@postgresql.org
Subject: Re: Insert Statements Hanging
Date: Wed, 25 Jul 2007 13:55:13 -0700
User-Agent: KMail/1.9.5
References: <46A7B216.2070608@livedatagroup.com>
In-Reply-To: <46A7B216.2070608@livedatagroup.com>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <200707251355.13174@hal.medialogik.com>

On Wednesday 25 July 2007 13:27, Pallav Kalva <pkalva@livedatagroup.com> 
wrote:
> I am hoping "SELECT 1 FROM ONLY "provisioning"."account" x WHERE
> "accountid" = $1 FOR UPDATE OF x" is causing the problem. If that is the
> case why doesnt it show in the pg_stat_activity view ? or am I missing
> something here ? what would be the reason for insert statement to hang
> like that ?

It's waiting for a lock, probably on one of the tables that it references 
for foreign keys.

8.1 or later would have that happen a lot less; they altered the locking 
requirements for foreign key lookups.

-- 
"It is a besetting vice of democracies to substitute public opinion for
law." - James Fenimore Cooper