Re: Status of gist locking in 8.1.3?

From: Francisco Reyes <lists(at)stringsutils(dot)com>
To: Chris <dmagick(at)gmail(dot)com>
Cc: PostgreSQL general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Status of gist locking in 8.1.3?
Date: 2006-05-30 03:55:38
Message-ID: cone.1148961338.277323.34675.1000@zoraida.natserv.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Chris writes:

>> Is there a way to tell what tables have locks on them?
>
> SELECT * from pg_locks ;
>
> (version 7.4 and above at least, don't have an install earlier than that).

And this is per DB right?

Any way to tell locks in all DBs?
In particular if planning to bounce back the DB would be nice to know if
anyone had any locks open..

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Chris 2006-05-30 05:58:03 Re: Status of gist locking in 8.1.3?
Previous Message Michael Glaesemann 2006-05-30 03:52:30 Re: whats the standard text search query?