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?