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.
