2008/3/14, Alvaro Herrera <alvherre@xxxxxxxxxxxxxxxxx>:> Clodoaldo escribió:>>> > Postgresql was restarted twice, but yes, it is as if the crash left> > some kind of permanent lock somewhere.>>> A prepared transaction perhaps? SELECT * FROM pg_prepared_xacts;>> A quick look into pg_locks should tell you if it's blocking. pg_prepared_xacts is empty and pg_locks has 288 rows: # select locktype, mode, count(*) as totalfrom pg_locks group by locktype, mode; locktype | mode | total---------------+------------------+------- transactionid | ExclusiveLock | 30 relation | RowExclusiveLock | 2 relation | AccessShareLock | 256(3 rows) Regards, Clodoaldo Pinto Neto -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)To make changes to your subscription:http://www.postgresql.org/mailpref/pgsql-general
