Re: slow queue-like empty table

From: Tobias Brox <tobias(at)nordicbet(dot)com>
To: Tobias Brox <tobias(at)nordicbet(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: slow queue-like empty table
Date: 2006-09-28 07:36:36
Message-ID: 20060928073636.GG14672@oppetid.no
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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? :-)

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Edoardo Ceccarelli 2006-09-28 08:44:05 Re: autovacuum on a -mostly- r/o table
Previous Message Tobias Brox 2006-09-28 06:56:31 slow queue-like empty table