"David Shadovitz" <david(at)www(dot)shadovitz(dot)com> 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:
As well as the pg_stat_activity view.
In response to
pgsql-performance by date
|Next:||From: Jenny Zhang||Date: 2003-12-16 23:52:41|
|Subject: update slows down in pl/pgsql function|
|Previous:||From: Neil Conway||Date: 2003-12-16 22:47:59|
|Subject: Re: Optimizing FK & PK performance...|