[ADMIN] Postgres log(pg_logs) have lots of message

2013-04-10 Thread 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

Re: [ADMIN] Postgres log(pg_logs) have lots of message

2013-04-10 Thread Bambi Bellows
-performa...@postgresql.org; pgsql-admin@postgresql.org Subject: [ADMIN] Postgres log(pg_logs) have lots of message 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

Re: [ADMIN] Postgres log(pg_logs) have lots of message

2013-04-10 Thread 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