From: | Ibrahim Harrani <ibrahim(dot)harrani(at)gmail(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | vacuum deadlock |
Date: | 2010-02-05 09:43:53 |
Message-ID: | 530068a1002050143n26ee05c6hda0de69f5ed97a9d@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi,
I am using PostgreSQL 8.3.7.
autovacuum is enabled in postgresql.conf
I got a deadlock while vacuuming all databases with vacuumdb command.
vacuumdb: vacuuming of database "mydb" failed: ERROR: deadlock detected
DETAIL: Process 1294 waits for AccessExclusiveLock on relation 2662 of
database ; blocked by process 1807.
Process 1807 waits for AccessShareLock on relation 1259 of database 16389;
blocked by process 1294.
I think, because of this lock, deleting a large table (15 million records)
was taking too much time
How can I know the name of the relations 2662 and 1259?
Do you have any ide about the problem and solution?
Thanks in advance.
From | Date | Subject | |
---|---|---|---|
Next Message | Yeb Havinga | 2010-02-05 12:36:10 | Re: vacuum deadlock |
Previous Message | Ian Lea | 2010-02-05 09:41:11 | Re: the question about round, truncate |