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

From Ray Stell
Subject Re: Major Performance decrease after some hours
Date
Msg-id 20061002122331.GA20952@cns.vt.edu
Whole thread Raw
In response to Re: Major Performance decrease after some hours  (MaXX <bs139412@skynet.be>)
Responses Re: Major Performance decrease after some hours
List pgsql-general
On Sun, Oct 01, 2006 at 12:55:51PM +0200, MaXX wrote:
>
> Pure speculation: are you sure you aren't vacuuming too agressively?
> The DELETE waiting and SELECT waiting sound to me like they are waiting
> for a lock that another vacuum is holding.

How would one determine the lock situation definitively?  Is there
an internal mechanism that can be queried?

pgsql-general by date:

Previous
From: Michelle Konzack
Date:
Subject: Re: pg web hosting with tsearch2?
Next
From: "Chris Hoover"
Date:
Subject: How to trace index to table?