X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 41C92D9D0B for ; Sun, 2 Oct 2005 13:43:03 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 26980-05 for ; Sun, 2 Oct 2005 16:42:59 +0000 (GMT) Received: from gwmta.wicourts.gov (gwmta2.wicourts.gov [165.219.244.92]) by svr1.postgresql.org (Postfix) with ESMTP id BA6C3D9BCD for ; Sun, 2 Oct 2005 13:42:58 -0300 (ADT) Received: from Courts-MTA by gwmta.wicourts.gov with Novell_GroupWise; Sun, 02 Oct 2005 11:42:56 -0500 Message-Id: X-Mailer: Novell GroupWise Internet Agent 6.5.4 Date: Sun, 02 Oct 2005 11:42:35 -0500 From: "Jeff Kirby" To: Subject: Vacuum Full Analyze Stalled Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: quoted-printable Content-Disposition: inline X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 required=5 tests=[none] X-Spam-Level: X-Archive-Number: 200510/10 X-Sequence-Number: 19082 I'm going to attempt to do my best in describing the situation... so = please forgive any ignorance on my part since I am very new to the = Postgres community. We have 2 identical Postgres databases, one on a Windows 2003 platform, = and the other on a SUSe 9.3 Linux platform (both platforms have identical = hardware). They both have the same schema, the same configuration = settings (as far as I can tell), and relatively the same amount of data = (approx 32GB). OK... here is the scoop, I started a "vacuum full analyze = verbose" on both last night... the windows box completed in about 1 1/2 = hours... the Linux box however is still chugging away this morning... and = appears to be stuck on vacuuming "pg_constraint_contypid_index". How do I = know... well I don't really... I'm inferring based on the order of the log = output on the Windows box. So the question is... has anyone experienced this problem in the past? If = so, what do you recommend to rectify the problem? Is it normal to be = running for more than 12 hours on a table that only has 35 rows? Do you = need me to attach the log output thus far from both the Windows and Linux = box? Any help here would be greatly appreciated. Any commands you can = suggest to run on the Linux machine... no problem. Jeffrey Kirby CCAP Web Team jeff.kirby@wicourts.gov 608-264-6253