Re: slow queue-like empty table

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



[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? :-)


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux