"Nimesh Satam" <nimesh.zedo@gmail.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
On Sat, Sep 30, 2006 at 02:55:54PM +0530, Nimesh Satam wrote:
> I am trying to vaccum one of the table using the following command:
>
> VACUUM FULL ANALYZE VERBOSE table_name;
Are you sure you want to do a vacuum full? Normally, that shouldn't be
required.
--
Jim Nasby jim@nasby.net
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)