Another vacuum problem

From: Denis Perchine <dyp(at)perchine(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Another vacuum problem
Date: 2000-12-21 04:14:01
Message-ID: 00122110140104.06971@dyp.perchine.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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(at)perchine(dot)com
HomePage: http://www.perchine.com/dyp/
FidoNet: 2:5000/120.5
----------------------------------

Browse pgsql-hackers by date

  From Date Subject
Next Message Ryan Kirkpatrick 2000-12-21 04:17:05 Re: [HACKERS] PostgreSQL pre-7.1 Linux/Alpha Status... (fwd)
Previous Message Ryan Kirkpatrick 2000-12-21 04:11:10 Re: [HACKERS] PostgreSQL pre-7.1 Linux/Alpha Status...