Received: from mail.x9media.com ([62.104.116.66]) by hub.org (8.9.3/8.9.3) with SMTP id MAA93647 for ; Fri, 27 Aug 1999 12:33:04 -0400 (EDT) (envelope-from frank@x9media.com) Received: from x9media.com (62.104.116.67) by mail.x9media.com with MERCUR-SMTP/POP3/IMAP4-Server (v3.10.14 XN-0098304) for ; Fri, 27 Aug 1999 18:36:40 +0200 Message-ID: <37C6BD4C.E81C0B21@x9media.com> Date: Fri, 27 Aug 1999 18:31:08 +0200 From: Frank Joerdens X-Mailer: Mozilla 4.6 [en] (Win95; I) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-sql@postgreSQL.org Subject: vacuum fails Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit vacuum fails with the following error: NOTICE: Rel beruf: Pages 18: Changed 0, Reapped 18, Empty 0, New 0; Tup 900: Vac 565, Crash 0, UnUsed 441, MinLen 60, . NOTICE: Ind idx_b: Pages 17; Tuples 900: Deleted 0. Elapsed 0/0 sec. NOTICE: Rel beruf: Pages: 18 --> 10. NOTICE: BlowawayRelationBuffers(beruf, 10): block 11 is referenced (private 0, last 0, global 1) FATAL 1: VACUUM (vc_vacheap): BlowawayRelationBuffers returned -2 what exactly does that mean? how do you recover from this? would i lose data if i dump the data from this table and recreate it? thanks frank