RE: How to prevent "no wait lock" after a connection drop

2018-08-03 Thread Ertan Küçükoğlu
> -Original Message- > From: Tom Lane > Sent: Wednesday, August 1, 2018 1:34 AM > To: Ertan Küçükoğlu > Cc: pgsql-gene...@postgresql.org > Subject: Re: How to prevent "no wait lock" after a connection drop > > =?iso-8859-9?B?RXJ0YW4gS/zn/Gtv8Gx1?= wr

Re: How to prevent "no wait lock" after a connection drop

2018-07-31 Thread Tom Lane
=?iso-8859-9?B?RXJ0YW4gS/zn/Gtv8Gx1?= writes: > What I observe during my tests is that if I intentionally drop internet > connection during any stage of data transfer (that is mostly while inserting > to tables) application gives error and stop. For next sync operation (which > runs every 5 mins)