Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 95F4047580D for ; Sat, 3 Aug 2002 18:59:50 -0400 (EDT) Received: from echo.computel.nl (echo.computel.nl [195.86.134.74]) by postgresql.org (Postfix) with ESMTP id D096A475165 for ; Sat, 3 Aug 2002 18:59:49 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by echo.computel.nl (Postfix) with SMTP id 593ED9DC6; Sun, 4 Aug 2002 00:59:52 +0200 (CEST) Received: from balefire10ww (e122144.upc-e.chello.nl [213.93.122.144]) by echo.computel.nl (Postfix) with ESMTP id B3A6F9DA4; Sun, 4 Aug 2002 00:59:51 +0200 (CEST) Message-ID: <001201c23b41$799a8d00$64c8a8c0@balefire10ww> From: "Sander Steffann" To: "Kristian Eide" , "Ken Corey" Cc: References: <035d01c23b2f$c5d49420$6b97f181@speed> <1028412884.28635.22.camel@kenlinux.bithub.org> <037901c23b3e$d542a140$6b97f181@speed> Subject: Re: VACUUM not doing its job? Date: Sun, 4 Aug 2002 00:59:51 +0200 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-AntiVirus: www.nederland.net e-mail virus scanner X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200208/101 X-Sequence-Number: 8947 > This is not good as the database is in use 24/7, and without the indexes > everything comes to a screeching halt. This means I probably will have to > stop the programs using the database for the time it takes to re-create the > indexes; this is better than having to dump/restore everything however :) You can try using REINDEX instead of dropping and creating the index. It takes an exclusive lock on the table (instead of a write-lock during CREATE INDEX) so your application will have to wait during reindex, but maybe it is faster... When you use the reindexdb script in the contrib dir you can even put it in a crontab. Sander