Search Postgresql Archives

Re: Major Performance decrease after some hours

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: Ray Stell <stellr@xxxxxxxxxx>
Subject: Re: Major Performance decrease after some hours
From: Tom Lane <tgl@xxxxxxxxxxxxx>
Date: Mon, 02 Oct 2006 10:59:42 -0400
Cc: MaXX <bs139412@xxxxxxxxx>, pgsql-general@xxxxxxxxxxxxxx
Comments: In-reply-to Ray Stell <stellr@xxxxxxxxxx> message dated "Mon, 02 Oct 2006 08:23:31 -0400"
In-reply-to: <20061002122331.GA20952@xxxxxxxxxx>
References: <764c9e910609302329y661d1300j2c0b1cdf23fd034@xxxxxxxxxxxxxx> <efo6s1$233r$1@xxxxxxxxxxxxxxxxxxx> <20061002122331.GA20952@xxxxxxxxxx>

Ray Stell <stellr@xxxxxxxxxx> writes:
> How would one determine the lock situation definitively?  Is there 
> an internal mechanism that can be queried?

pg_locks view.

			regards, tom lane

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Follow-Ups:
- Re: Major Performance decrease after some hours
  - From: Peter Bauer

References:
- Major Performance decrease after some hours
  - From: Peter Bauer
- Re: Major Performance decrease after some hours
  - From: MaXX
- Re: Major Performance decrease after some hours
  - From: Ray Stell

Prev by Date: Re: How to trace index to table?
Next by Date: FlushRelationBuffers Error
Previous by thread: Re: Major Performance decrease after some hours
Next by thread: Re: Major Performance decrease after some hours
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux