On Thu, Oct 31, 2013 at 11:51 AM, Gary Fu <g...@sigmaspace.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)
