Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Postgres log(pg_logs) have lots of message

41 views
Skip to first unread message

Nik Tek

unread,
Apr 10, 2013, 5:58:11 PM4/10/13
to
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

Nik Tek

unread,
Apr 10, 2013, 6:05:55 PM4/10/13
to
Hi Bambi,

Thank you the prompt reply.

This table is very volatile, lot of inserts/updates happen on this tables(atleast 20~30 inserts/min).
When auto vacuum tries to run on this table, I get this warning.

Is there a way, I force it to happen, because the table/indexes statistics are becoming stale very quickly.

Thank you
Nik
0 new messages