Received: from redbox.venux.net (redbox.venux.net [216.47.238.10]) by hub.org (8.9.3/8.9.3) with ESMTP id UAA01662 for ; Fri, 19 Nov 1999 20:04:10 -0500 (EST) (envelope-from matthew@venux.net) Received: from thunder (net4842.hcv.com [216.93.48.42]) by redbox.venux.net (Postfix) with SMTP id 2B0D62E227 for ; Fri, 19 Nov 1999 19:56:49 -0500 (EST) Message-Id: <4.1.19991119195147.00a16ef0@mail.venux.net> X-Sender: mhagerty@mail.venux.net X-Mailer: QUALCOMM Windows Eudora Pro Version 4.1 Date: Fri, 19 Nov 1999 20:03:57 -0500 To: pgsql-sql@postgreSQL.org From: Matthew Hagerty Subject: Deleting indexes before vacuum? Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Greetings, I read a post sometime back where someone said their normal routine for running a vacuum was to delete the indexes first, then recreate them after the vacuum. Is this necessary? If the indexes are gone does vacuum analyze still make sense? I am concerned about this because I never removed the indexes prior to vacuum, but today I executed this simple query: select note_id from appnotes where note_id=6068; note_id ------- 17768 (1 row) This was rather alarming, so I deleted all the indexes, ran vacuum, recreated the indexes. Now the query works: select note_id from appnotes where note_id=6068; note_id ------- 6068 (1 row) What are the general rules about running vacuum, frequency of use, etc.? I am running pg-6.4 (I know it needs an update) on this particular server and 6.5.x on others. Thanks, Matthew Hagerty