"Nimesh Satam" <nimesh(dot)zedo(at)gmail(dot)com> 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