> Alvaro Herrera Munoz <[EMAIL PROTECTED]> writes:
> > On Wed, Jul 30, 2003 at 01:03:55PM -0500, Adam Kavan wrote:
> >> I have found the problem (I think) below is the list of all the locks
> >> pending on the relation. The relation is a hash index on the table
that is
> >> being INSERT'd rapidly.
On Wed, Jul 30, 2003 at 01:03:55PM -0500, Adam Kavan wrote:
> I have found the problem (I think) below is the list of all the locks
> pending on the relation. The relation is a hash index on the table that is
> being INSERT'd rapidly. From what I can see pid 10024 and 10025 both have
> an Exclus
- Original Message -
From: "Tom Lane" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, July 30, 2003 9:25 AM
Subject: Re: [GENERAL] Postgres Hanging on Inserts
> Adam Kavan <[EMAIL PROTECTED]> writes:
> > I lo
Adam Kavan <[EMAIL PROTECTED]> writes:
> I looked into pg_locks and they are all waiting to get an exclusive
> lock on the same relation. Is there anyway for me to tell what this
> relation is?
To decipher the OIDs in pg_locks, join against pg_class.oid, or just do
select relname from pg_
