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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
