JC Praud escribió: > On Wed, Oct 28, 2009 at 12:29 AM, Alvaro Herrera <alvherre@xxxxxxxxxxxxxxxxx > > This bit does not make much sense to me. A transaction waiting will not > > show up in the log. Were they cancelled? Can you paste an extract from > > the log? > > No, the transactions were not cancelled. All I saw in he pg_log is this > (taken at the time le lock was lifted): > > 2009-10-27 05:39:19 CET dbuser dbase 10.33.10.133 LOG: process 14866 still > waiting for RowExclusiveLock on relation 26683 of database 23806 after > 5000.271 ms Oh, you have log_lock_waits enabled. It makes plenty of sense now, thanks. -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
