X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 35CCC53B4B for ; Wed, 20 Apr 2005 20:30:47 -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 78633-08 for ; Wed, 20 Apr 2005 23:30:36 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 6FD815383C for ; Wed, 20 Apr 2005 20:30:35 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id j3KNUbBu002120; Wed, 20 Apr 2005 19:30:38 -0400 (EDT) To: FBaron@co.belcorp.biz Cc: pgsql-admin@postgresql.org Subject: Re: VACUUM with a small table too much delayed. In-reply-to: References: Comments: In-reply-to FBaron@co.belcorp.biz message dated "Wed, 20 Apr 2005 16:26:40 -0500" Date: Wed, 20 Apr 2005 19:30:37 -0400 Message-ID: <2119.1114039837@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.27 tagged_above=0 required=5 tests=AWL, BIZ_TLD X-Spam-Level: X-Archive-Number: 200504/292 X-Sequence-Number: 17305 FBaron@co.belcorp.biz writes: > Hi, I'm running a vaccum process to a table with 1427 records and three > indexes with the same size. This process is running 6 hours ago and does > not finish, I had to kill it. Was it actually *doing* anything, or just sitting? Perhaps it was waiting for some other process's lock. > This is the VACUUM message after cancel > INFO: --Relation public.unical_ejitem-- > INFO: Pages 416: Changed 0, reaped 396, Empty 0, New 0; Tup 1427: Vac > 20993, Keep/VTL 0/0, UnUsed 0, MinLen 130, MaxLen 150; Re-using: > Free/Avail. Space 3102472/3101520; EndEmpty/Avail. Pages 0/397. > CPU 0.02s/0.00u sec elapsed 3.48 sec. Hmm ... VACUUM hasn't printed messages that looked like that since 7.3 ... you might want to think about an update sometime. regards, tom lane