Postgres log(pg_logs) have lots of message

[Nik Tek]

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]

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