[GENERAL] PG 7.0 vacuum problem

2000-05-25 Thread Marcin Inkielman
HI! i rescently upgraded my system from PG6.53 to PG7.0. after a few days of work i am unable to do a vacuum on one of tables: nat=# VACUUM verbose analyze osoby; NOTICE: --Relation osoby-- NOTICE: Pages 189: Changed 0, reaped 24, Empty 0, New 0; Tup 3436: Vac 29, Keep/VTL 0/0, Crash 0,

Re: [GENERAL] PG 7.0 vacuum problem

2000-05-25 Thread Tom Lane
Marcin Inkielman [EMAIL PROTECTED] writes: i rescently upgraded my system from PG6.53 to PG7.0. after a few days of work i am unable to do a vacuum on one of tables: nat=# VACUUM verbose analyze osoby; NOTICE: FlushRelationBuffers(osoby, 182): block 186 is referenced (private 0, global 3)

Re: [GENERAL] PG 7.0 vacuum problem

2000-05-25 Thread Marcin Inkielman
On Thu, 25 May 2000, Tom Lane wrote: Date: Thu, 25 May 2000 19:49:00 -0400 From: Tom Lane [EMAIL PROTECTED] To: Marcin Inkielman [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: [GENERAL] PG 7.0 vacuum problem Marcin Inkielman [EMAIL PROTECTED] writes: i rescently upgraded my