Hello,
Thanks for all replies.
> The perf top output suggests the possibility of a corrupted index,
> causing an endless loop.
Yes! Rebuilding indexes solves problem for this table. :)
But after 20h problem is back on another table. First table has about 2m records, second has only 200k.
> There is a bug fix in 9.4.5 which can cause a deadlock on
> lightweight locking.
I've just upgraded to 9.4.5 and hope that helps. I'll keep you posted.
Best Regards,
Michal