Received: from guerilla.foo.bar (hennen32s.iserlohn.netsurf.de [194.195.194.226]) by hub.org (8.9.2/8.9.1) with SMTP id OAA63450 for ; Thu, 18 Mar 1999 14:58:37 -0500 (EST) (envelope-from schumann@schell.de) Received: (qmail 8691 invoked from network); 18 Mar 1999 20:59:08 +0100 Received: from flaubert.foo.bar (192.168.0.99) by guerilla.foo.bar with SMTP; 18 Mar 1999 20:59:07 +0100 Received: (qmail 11598 invoked by uid 500); 18 Mar 1999 19:58:31 -0000 Date: Thu, 18 Mar 1999 20:58:31 +0100 From: Sascha Schumann To: Tim Stoddard Cc: pgsql-sql@postgresql.org Subject: Re: [SQL] Vacuum Message-ID: <19990318205831.B11537@schell.de> References: <36F11091.6E5C6C43@dcs.state.ar.us> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Mailer: Mutt 0.95.1i In-Reply-To: <36F11091.6E5C6C43@dcs.state.ar.us>; from Tim Stoddard on Thu, Mar 18, 1999 at 08:41:21AM -0600 X-Operating-System: Linux 2.2.2-ac7 alpha On Thu, Mar 18, 1999 at 08:41:21AM -0600, Tim Stoddard wrote: > When I delete 2k-3k of records from a table the vacuum process seems > to take forever. I have let the vacuum run for 24 hours before with > not luck. > > Can someone one explain to me what is going on? Funny, there is/was just a whole thread about that on hackers. There seem to be some agreement that this will be reworked/faster in 6.6, but you cannot avoid it currently. The main cause for this is the usage of indeces. Did you pass -o -F to the postmaster? It can improve the speed of PostgreSQL dramatically. -- Regards, Sascha Schumann | Consultant | finger sas@schell.de | for PGP public key