"David Shadovitz" <[EMAIL PROTECTED]> writes: > I'm running PG 7.2.2 on RH Linux 8.0.
Note that this version of PostgreSQL is quite old. > I'd like to know why "VACUUM ANALYZE <table>" is extemely slow (hours) for > certain tables. Is there another concurrent transaction that has modified the table but has not committed? VACUUM ANALYZE will need to block waiting for it. You might be able to get some insight into this by examining the pg_locks system view: http://www.postgresql.org/docs/current/static/monitoring-locks.html As well as the pg_stat_activity view. -Neil ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
