Received: from nsi.edu (amethea.nsi.edu [198.133.185.9]) by hub.org (8.9.2/8.9.1) with ESMTP id KAA38837 for ; Thu, 4 Mar 1999 10:10:05 -0500 (EST) (envelope-from reina@nsi.edu) Received: from nsi.edu (IDENT:reina@bigred.nsi.edu [204.128.156.214]) by nsi.edu (8.9.1/8.9.1) with ESMTP id HAA07051; Thu, 4 Mar 1999 07:09:50 -0800 (PST) Sender: reina@nsi.edu Message-ID: <36DEA2BE.D604D9C8@nsi.edu> Date: Thu, 04 Mar 1999 15:11:58 +0000 From: "G. Anthony Reina" Organization: The Neurosciences Institute X-Mailer: Mozilla 4.5 [en] (X11; U; Linux 2.2.1 i686) X-Accept-Language: en MIME-Version: 1.0 To: Tim Perdue CC: pgsql-sql@hub.org Subject: Re: [SQL] Correction - not crash References: <005e01be6642$99fea630$0b8c5aa5@timnt.weather.net> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Tim, It sounds like one of your table indicies became corrupted. I had a similar thing happen to me before. To test this, try vacuuming each table separately (i.e. 'vacuum verbose analyze tablename'). If each table vacuums separately, then it is a problem with the main index (the table of tables). In this case, you'll probably have to pg_dump and restore the database (or possibly first try to drop the indicies and re-create them). -Tony