"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
In response to
pgsql-performance by date
|Next:||From: Steve Martin||Date: 2006-10-02 02:26:52|
|Subject: selecting data from information_schema.columns performance.|
|Previous:||From: Markus Schaber||Date: 2006-09-30 09:50:33|
|Subject: Re: how to optimize postgres 8.1|