Skip site navigation (1) Skip section navigation (2)

Re: Why is VACUUM ANALYZE <table> so slow?

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 (view raw or flat)
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


In response to

pgsql-performance by date

Next:From: Jenny ZhangDate: 2003-12-16 23:52:41
Subject: update slows down in pl/pgsql function
Previous:From: Neil ConwayDate: 2003-12-16 22:47:59
Subject: Re: Optimizing FK & PK performance...

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group