Postgres Pro
Downloads
Home   >   mailing lists

Re: autovaccum task got cancelled - Mailing list pgsql-general

From bricklen
Subject Re: autovaccum task got cancelled
Date
Msg-id CAGrpgQ9bHzfrCwzbzj0msUiU+LOd+7qXFYuoLgjstD8GQ8-VVg@mail.gmail.com
Whole thread Raw
In response to autovaccum task got cancelled  (Gary Fu <gfu@sigmaspace.com>)
List pgsql-general
Tree view
On Thu, Oct 31, 2013 at 11:51 AM, Gary Fu <gfu@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)

pgsql-general by date:

Previous
From: Gary Fu
Date:
Subject: autovaccum task got cancelled
Next
From: john gale
Date:
Subject: Hstore::TooBig ?