Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group