Re: Major Performance decrease after some hours

From: Ray Stell <stellr(at)cns(dot)vt(dot)edu>
To: MaXX <bs139412(at)skynet(dot)be>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Major Performance decrease after some hours
Date: 2006-10-02 12:23:31
Message-ID: 20061002122331.GA20952@cns.vt.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Chris Hoover 2006-10-02 13:19:32 How to trace index to table?
Previous Message Dirk Hartmann 2006-10-02 11:56:29