Request a Demo
Home   >   mailing lists

Re: locks problem - Mailing list pgsql-sql

From Marcin Krawczyk
Subject Re: locks problem
Date
Msg-id CABnqL33P8G4RafZTMu1zGBP8MZ_KPjp=Ns=aqnfkHYwKa7CRBQ@mail.gmail.com
Whole thread
In response to locks problem  (Marcin Krawczyk <jankes.mk@gmail.com>)
List pgsql-sql
Tree view

Ok I figured it out. I had a prepared transaction holding the locks. The pg_prepared_xacts was helpful.

27-11-2012 10:27, "Marcin Krawczyk" <jankes.mk@gmail.com> napisał(a):

Hi list,

I've got a locking problem which prevents me from doing some alters on my tables. When I looked into pg_locks I saw a lot of entries (around 1000) with pid being NULL and almost all of them are AccessShare. Can anyone tell me what might those be and how do I get rid of them ?

pgsql-sql by date:

Previous
From: Thomas Kellerer
Date:
Subject: Using regexp_matches in the WHERE clause
Next
From: Willem Leenen
Date:
Subject: Re: Using regexp_matches in the WHERE clause