Postgres Pro
Downloads
Home   >   mailing lists

Re: Major Performance decrease after some hours - Mailing list pgsql-general

From Tom Lane
Subject Re: Major Performance decrease after some hours
Date
Msg-id 10714.1159801182@sss.pgh.pa.us
Whole thread Raw
In response to Re: Major Performance decrease after some hours  (Ray Stell <stellr@cns.vt.edu>)
Responses Re: Major Performance decrease after some hours
List pgsql-general
Tree view 
Ray Stell <stellr@cns.vt.edu> writes:
> How would one determine the lock situation definitively?  Is there
> an internal mechanism that can be queried?

pg_locks view.

            regards, tom lane

pgsql-general by date:

Previous
From: "Ardian Xharra"
Date:
Subject: Re: How to trace index to table?
Next
From: "rlee0001"
Date:
Subject: Re: Normal vs Surrogate Primary Keys...