Re: autovaccum task got cancelled

On Thu, Oct 31, 2013 at 11:51 AM, Gary Fu <gfu(at)sigmaspace(dot)com> wrote:

> Hello,
>
> I'm running an application (with programs in Perl) through pgpool 3.1 with
> replication mode to two postgresql db servers (version 9.0.13). Recently,
> I noticed that the following messages repeatedly showed in postgres log
> files. As far as I know, the application programs do not make any specific
> lock on the 'file' table. I'm not sure if it is caused by the pgpool or
> something else.
>

Try setting your log_line_prefix so that more details are logged, that
might help track down where the locks etc are coming from.
Eg
log_line_prefix = '%m [%p] (user=%u) (db=%d) (rhost=%h) [vxid:%v txid:%x]
[%i] '

and reload your config (eg. "select pg_reload_conf()" as the superuser)