Re: [ADMIN] Re: [SQL] I cannot vacuum

2001-03-21 Thread Tom Lane
Jie Liang <[EMAIL PROTECTED]> writes: > Dose later version such as 7.0.3 resolved this problem?? Possibly. Try it and see. You should be running 7.0.3 anyway, just on general principles. regards, tom lane ---(end of broadcast)---

Re: [ADMIN] Re: [SQL] I cannot vacuum

2001-03-21 Thread Jie Liang
Tom, NOTICE: --Relation ip-- NOTICE: Pages 4244: Changed 1, reaped 13, Empty 0, New 0; Tup 665627: Vac 32, Keep/VTL 0/0, Crash 0, UnUsed 594, MinLen 48, MaxLen 48; Re-using: Free/Avail. Space 33168/26016; EndEmpty/Avail. Pages 0/12. CPU 0.32s/2.26u sec. NOTICE: Index ip_ip: Pages 3204; Tuples

[ADMIN] Re: [SQL] I cannot vacuum

2001-03-20 Thread Tom Lane
Jie Liang <[EMAIL PROTECTED]> writes: > NOTICE: FlushRelationBuffers(ip, 4223): block 4365 is referenced (private > 0, global 8) > FATAL 1: VACUUM (vc_vacheap): FlushRelationBuffers returned -2 Try restarting your postmaster. regards, tom lane -