"Nimesh Satam" <nimesh.zedo@xxxxxxxxx> writes: > I am trying to vaccum one of the table using the following command: > VACUUM FULL ANALYZE VERBOSE table_name; > But for some reason the table vaccuming is not going ahead. VACUUM FULL requires exclusive lock on the table, so it's probably waiting for some open transaction that has a reader's or writer's lock on it. Look in pg_stat_activity and pg_locks to find out more. regards, tom lane
