On 02 Apr 2014, at 20:13, Victor Sterpu <victor@xxxxxxxx> wrote: > There may pass a few days or weeks until next lock. > But I don't undesrtand why the whole table is locked if there is one uncommited transaction. > > The following scenario might be the cause: > 1. Transaction is started > 2. the client application is closed because of a power surge, the started transaction will never be commited > 3. from the server point of view there is a unfinished transaction that will block future statements > > Is this normal behaviour? I’m pretty sure that with such a powersurge the connection gets closed, causing the transaction to roll back. Alban Hertroys -- If you can't see the forest for the trees, cut the trees and you'll find there is no forest. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
