2008/3/14, Alvaro Herrera <[EMAIL PROTECTED]>: > 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 total from 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 ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
