Thomas Chille wrote:
> I think this are the relevant pg_locks entries:
>
> relation 75685778 75686189
> 9017862 25467 AccessShareLock f
> relation 75685778 75686189
> 9009323 9317 ShareUpdateExclusiveLock
> t
> relation 75685778 75686189
> 9009312 9293 AccessShareLock t
> relation 75685778 75686189
> 9009312 9293 RowExclusiveLock t
> relation 75685778 75686189
> 9009312 9293 AccessExclusiveLock f
> relation 75685778 75686189
> 9012978 28370 AccessShareLock f
>
> 75686189 is the table hst_timerecording. for me it looks like the
> autovacuum is not releasing the blocking ShareUpdateExclusiveLock?
What are the column headings? I find this difficult to read.
Please post the whole of pg_locks. I may be missing something but I
think we're missing part of the picture here. Autovacuum does not seem
to be locking on anything.
--
Alvaro Herrera http://www.amazon.com/gp/registry/CTMLCN8V17R4
One man's impedance mismatch is another man's layer of abstraction.
(Lincoln Yeoh)