| From: | Nik Tek <niktek2005(at)gmail(dot)com> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org, pgsql-admin(at)postgresql(dot)org |
| Subject: | Postgres log(pg_logs) have lots of message |
| Date: | 2013-04-10 21:58:11 |
| Message-ID: | CAHySzWXT5RF30cFOARSq1HqNxO7v0TBuigWaV4NedEtwWrda=Q@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-performance |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bambi Bellows | 2013-04-10 22:00:13 | Re: Postgres log(pg_logs) have lots of message |
| Previous Message | ktm@rice.edu | 2013-04-10 18:16:56 | Re: [SQL] Encrypting PGBouncer to Postgres DB connections |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bambi Bellows | 2013-04-10 22:00:13 | Re: Postgres log(pg_logs) have lots of message |
| Previous Message | Tory M Blue | 2013-04-10 21:53:40 | Re: Postgresql.conf file from like 7.x to 9.2 |