Postgres Pro
Downloads
Home   >   mailing lists

Postgres log(pg_logs) have lots of message - Mailing list pgsql-performance

From Nik Tek
Subject Postgres log(pg_logs) have lots of message
Date
Msg-id CAHySzWXT5RF30cFOARSq1HqNxO7v0TBuigWaV4NedEtwWrda=Q@mail.gmail.com
Whole thread Raw
List pgsql-performance
Tree view
Hi,

Could some please explain what these warnings mean in postgres.
I see these messages a lot when automatic vacuum runs.

      1 tm:2013-04-10 11:39:20.074 UTC db: pid:13766 LOG:  automatic vacuum of table "DB1.nic.pvxt": could not (re)acquire exclusive lock for truncate scan
      1 tm:2013-04-10 11:40:22.849 UTC db: pid:14286 LOG:  automatic vacuum of table "DB1.nic.pvxt": could not (re)acquire exclusive lock for truncate scan
      1 tm:2013-04-10 11:41:17.500 UTC db: pid:14491 LOG:  automatic vacuum of table "DB1.nic.pvxt": could not (re)acquire exclusive lock for truncate scan

Thank you
Nik

pgsql-performance by date:

Previous
From: Tory M Blue
Date:
Subject: Re: Postgresql.conf file from like 7.x to 9.2
Next
From: Nik Tek
Date:
Subject: Re: [ADMIN] Postgres log(pg_logs) have lots of message