From: Alan Hodgson <ahodgson@simkin.ca>
To: pgsql-performance@postgresql.org
Subject: Re: Insert Statements Hanging
Date: Wed, 25 Jul 2007 13:55:13 -0700
Message-ID: <200707251355.13174@hal.medialogik.com> (raw)
In-Reply-To: <46A7B216.2070608@livedatagroup.com>
References: <46A7B216.2070608@livedatagroup.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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: ahodgson@simkin.ca
Subject: Re: Insert Statements Hanging
In-Reply-To: <200707251355.13174@hal.medialogik.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox