Re: slow queue-like empty table - Mailing list pgsql-performance

From Tobias Brox
Subject Re: slow queue-like empty table
Date
Msg-id 20060928073636.GG14672@oppetid.no
Whole thread Raw
In response to slow queue-like empty table  (Tobias Brox <tobias@nordicbet.com>)
Responses Re: slow queue-like empty table  (Csaba Nagy <nagy@ecircle-ag.com>)
List pgsql-performance
[Tobias Brox - Thu at 08:56:31AM +0200]
> It really seems like some transaction is still viewing the queue, since
> it found 38k of non-removable rows ... but how do I find the pid of the
> transaction viewing the queue?  As said, the pg_locks didn't give me any
> hints ...

Dropping the table and recreating it solved the immediate problem, but
there must be some better solution than that? :-)

pgsql-performance by date:

Previous
From: Tobias Brox
Date:
Subject: slow queue-like empty table
Next
From: Edoardo Ceccarelli
Date:
Subject: Re: autovacuum on a -mostly- r/o table