Re: Status of gist locking in 8.1.3? - Mailing list pgsql-general

From Francisco Reyes
Subject Re: Status of gist locking in 8.1.3?
Date
Msg-id cone.1148956358.428360.34675.1000@zoraida.natserv.net
Whole thread Raw
In response to Status of gist locking in 8.1.3?  (Francisco Reyes <lists@stringsutils.com>)
Responses Re: Status of gist locking in 8.1.3?
List pgsql-general
Tom Lane writes:

> CREATE INDEX shouldn't block any concurrent SELECT, regardless of which
> index AM is involved.

The problem was that the table needed a "vacuum full". It was a large table
and had done a massive update. It is not that it was blocked, but that it
was just taking a very long time.

Is there a way to tell what tables have locks on them?


pgsql-general by date:

Previous
From: "Greg Sabino Mullane"
Date:
Subject: Re: National Number to text conversion
Next
From: Chris
Date:
Subject: Re: Status of gist locking in 8.1.3?