| From: | Neil Conway <neilc(at)samurai(dot)com> |
|---|---|
| To: | "David Shadovitz" <david(at)www(dot)shadovitz(dot)com> |
| Cc: | pgsql-performance(at)postgresql(dot)org, david(at)shadovitz(dot)com |
| Subject: | Re: Why is VACUUM ANALYZE <table> so slow? |
| Date: | 2003-12-16 22:51:18 |
| Message-ID: | 87brq8l6l5.fsf@mailbox.samurai.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
"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:
http://www.postgresql.org/docs/current/static/monitoring-locks.html
As well as the pg_stat_activity view.
-Neil
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jenny Zhang | 2003-12-16 23:52:41 | update slows down in pl/pgsql function |
| Previous Message | Neil Conway | 2003-12-16 22:47:59 | Re: Optimizing FK & PK performance... |