Dear All, Thanks in advance. I found below deadlock in postgresql logs. I cannot change calling of REINDEX and insert query sequence because it is execute automatically through some cron script.
ERROR: deadlock detected DETAIL: Process 2234 waits for AccessShareLock on relation 16459 of database 16385; blocked by process 4111. Process 4111 waits for ShareLock on relation 16502 of database 16385; blocked by process 2234. Process 2234: INSERT INTO table1 ( id , unique_id )VALUES( '1', '4') Process 4111: REINDEX TABLE table1 Could you please provide any solution to resolve this deadlock. Regards, Yogesh -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
