Re: [GENERAL] autovaccum task got cancelled

2013-11-02 Thread Gary Fu
On 11/01/13 03:23, Kevin Grittner wrote: Sergey Konoplev wrote: 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. [...] 2013-10-31 18:01:30 UTCLOG: sending cancel to blocking autovacu

Re: [GENERAL] autovaccum task got cancelled

2013-11-01 Thread Kevin Grittner
Sergey Konoplev wrote: >> 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. > > [...] > >> 2013-10-31 18:01:30 UTCLOG:  sending cancel to blocking autovacuum PID 8614 >> 2013-10-31 18:

Re: [GENERAL] autovaccum task got cancelled

2013-10-31 Thread Sergey Konoplev
On Thu, Oct 31, 2013 at 11:51 AM, Gary Fu wrote: > 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

Re: [GENERAL] autovaccum task got cancelled

2013-10-31 Thread bricklen
On Thu, Oct 31, 2013 at 11:51 AM, Gary Fu 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.

[GENERAL] autovaccum task got cancelled

2013-10-31 Thread Gary Fu
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 a