Postgres Pro
Downloads
Home   >   mailing lists

Thread: Table not getting vaccumed.

Table not getting vaccumed.

From
"Nimesh Satam"
Date:
Hi,
 
 
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. Can you guys let me know what the problem is.
 
Regards,
Nimesh.

Re: Table not getting vaccumed.

From
Tom Lane
Date:
"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

Re: Table not getting vaccumed.

From
"Jim C. Nasby"
Date:
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)