Re: autovaccum task got cancelled

Поиск
Список
Период
Сортировка
От bricklen
Тема Re: autovaccum task got cancelled
Дата
Msg-id CAGrpgQ9bHzfrCwzbzj0msUiU+LOd+7qXFYuoLgjstD8GQ8-VVg@mail.gmail.com
обсуждение исходный текст
Ответ на autovaccum task got cancelled  (Gary Fu <gfu@sigmaspace.com>)
Список pgsql-general
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 по дате отправления:

Предыдущее
От: Gary Fu
Дата:
Сообщение: autovaccum task got cancelled
Следующее
От: john gale
Дата:
Сообщение: Hstore::TooBig ?