Kevin Kempter <kevin@xxxxxxxxxxxxxxxxxxx> writes: > Then I ran this: > postgres=# select relation from pg_locks where pid = 9902; > relation > ----------- > 82097999 > 143763216 > 143763215 > 143763193 > 143763193 > 143763217 > (7 rows) > However none of these seem to have a corresponding pg_class oid, see > the below queries: This most likely means that the vacuum is happening in a different database than you are looking in. Did you check pg_stat_activity.datname? regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
