Postgres Pro
Downloads
Home   >   mailing lists

Re: Table not getting vaccumed. - Mailing list pgsql-performance

From Tom Lane
Subject Re: Table not getting vaccumed.
Date
Msg-id 13551.1159634750@sss.pgh.pa.us
Whole thread Raw
In response to Table not getting vaccumed.  ("Nimesh Satam" <nimesh.zedo@gmail.com>)
List pgsql-performance
Tree view 
"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

pgsql-performance by date:

Previous
From: Markus Schaber
Date:
Subject: Re: how to optimize postgres 8.1
Next
From: Steve Martin
Date:
Subject: selecting data from information_schema.columns performance.