Re: Request to share information regarding deadlock in postgresql-9.3.6

On 11/16/2016 6:22 PM, Yogesh Sharma wrote:
> process 5764 is waiting for relation (table) with OID 16459(table2_primary_key), that table is blocked by process 4970 and process 4970 is waiting for a lock on another table, OID 16502(table1), which the first process has a lock on.
> Process 5764: INSERT INTO table2 ( id , roll_number, name) VALUES( '1', '4','abc' )
> Process 4970: REINDEX TABLE table1, table2 etc..
>
> How to resolve this problem?

don't do reindex when the tables are in use.

or

why does process 5764 have a lock on table 1 while its inserting into 
table 2?

or

do each reindex as a seperate transaction so only one table gets locked 
at a time.

-- 
john r pierce, recycling bits in santa cruz