X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 7FFABD1B4BD for ; Tue, 16 Dec 2003 22:51:49 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 24367-07 for ; Tue, 16 Dec 2003 18:51:20 -0400 (AST) Received: from bob.samurai.com (bob.samurai.com [205.207.28.75]) by svr1.postgresql.org (Postfix) with ESMTP id B9369D1B4A8 for ; Tue, 16 Dec 2003 18:51:17 -0400 (AST) Received: from tokyo.samurai.com (d226-89-59.home.cgocable.net [24.226.89.59]) by bob.samurai.com (Postfix) with ESMTP id 177A72357; Tue, 16 Dec 2003 17:51:19 -0500 (EST) To: "David Shadovitz" Cc: pgsql-performance@postgresql.org, david@shadovitz.com Subject: Re: Why is VACUUM ANALYZE so slow? From: Neil Conway In-Reply-To: <20031209211444.M99946@www.shadovitz.com> (David Shadovitz's message of "Tue, 9 Dec 2003 14:14:44 -0700") References: <20031209211444.M99946@www.shadovitz.com> Date: Tue, 16 Dec 2003 17:51:18 -0500 Message-ID: <87brq8l6l5.fsf@mailbox.samurai.com> User-Agent: Gnus/5.1002 (Gnus v5.10.2) XEmacs/21.4 (Reasonable Discussion, linux) MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200312/241 X-Sequence-Number: 5101 "David Shadovitz" 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
" 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