From: Ibrahim Harrani <ibrahim.harrani@gmail.com>
To: pgsql-admin@postgresql.org
Subject: vacuum deadlock
Date: Fri, 5 Feb 2010 11:43:53 +0200
Message-ID: <530068a1002050143n26ee05c6hda0de69f5ed97a9d@mail.gmail.com> (raw)
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: ibrahim.harrani@gmail.com
Subject: Re: vacuum deadlock
In-Reply-To: <530068a1002050143n26ee05c6hda0de69f5ed97a9d@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox