Thread: Another vacuum problem

Another vacuum problem

From
Denis Perchine
Date:
Hello,

Anyone have any clues why such crap can happend?

slygreetings=# vacuum verbose analyze statistic;
NOTICE:  --Relation statistic --
NOTICE:  Pages 498: Changed 1, reaped 490, Empty 0, New 0; Tup 1167: Vac 0, 
Keep/VTL 1110/1110, Crash 0, UnUsed 76888, MinLen 48, MaxLen 48; Re-using: 
Free/Avail. Space 3700424/3700424; EndEmpty/Avail. Pages 0/490. CPU 
0.05s/0.02u sec.
NOTICE:  Index statistic_date_vid_key: Pages 458; Tuples 1167: Deleted 0. CPU 
0.05s/0.00u sec.
NOTICE:  Too old parent tuple found - can't continue vc_repair_frag
NOTICE:  Rel statistic: Pages: 498 --> 498; Tuple(s) moved: 0. CPU 
0.00s/0.01u sec.
VACUUM 

-- 
Sincerely Yours,
Denis Perchine

----------------------------------
E-Mail: dyp@perchine.com
HomePage: http://www.perchine.com/dyp/
FidoNet: 2:5000/120.5
----------------------------------