Received: from mta3.snfc21.pbi.net (mta3.snfc21.pbi.net [206.13.28.141]) by hub.org (8.9.3/8.9.3) with ESMTP id GAA16538 for ; Mon, 25 Oct 1999 06:54:41 -0400 (EDT) (envelope-from postgres@weblynk.com) Received: from pinto.usedcars.com ([206.170.239.155]) by mta3.snfc21.pbi.net (Sun Internet Mail Server sims.3.5.1999.09.16.21.57.p8) with SMTP id <0FK5003XGNN198@mta3.snfc21.pbi.net> for pgsql-sql@postgreSQL.org; Mon, 25 Oct 1999 03:54:37 -0700 (PDT) Date: Mon, 25 Oct 1999 03:52:18 -0700 From: Postgres Subject: Vacuum takes more than 1 hr To: "pgsql-sql@postgresql.org" Message-id: <001001bf1ed7$01dc9b20$9befaace@usedcars.com> MIME-version: 1.0 X-Mailer: Microsoft Outlook Express 5.00.2314.1300 Content-type: text/plain; charset="iso-8859-1" Content-transfer-encoding: 7bit X-MSMail-Priority: Normal X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300 References: X-Priority: 3 I have a table with about 30 columns and 200K rows. When I perform a vacuum on it (no analyze) it takes usually a little more than 1 hour. Since I do it everyday, for me, this basically means my database, which is now getting about a million queries a month, is down for an hour every day, since all selects to that table wait until the vacuum is done. I have smaller tables, 10 columns, 5K rows, which see, to be very quick with vacuum. Any ideas on how to speed vacuum up? Thanks, Rich