Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Table not getting vaccumed.
- From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
- To: "Nimesh Satam" <nimesh(dot)zedo(at)gmail(dot)com>
- Cc: pgsql-performance(at)postgresql(dot)org
- Subject: Re: Table not getting vaccumed.
- Date: Sat, 30 Sep 2006 12:45:50 -0400
"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
- References:
- Table not getting vaccumed.
- From: Nimesh Satam
- Table not getting vaccumed.
- Prev by Date: Re: how to optimize postgres 8.1
- Previous by thread: Table not getting vaccumed.
- Indexes: