Re: auto truncate/vacuum full

JC Praud escribió:

> On Wed, Oct 28, 2009 at 12:29 AM, Alvaro Herrera <alvherre@commandprompt.com

> > 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.