FBaron@co.belcorp.biz writes:
> Hi, I'm running a vaccum process to a table with 1427 records and three
> indexes with the same size. This process is running 6 hours ago and does
> not finish, I had to kill it.
Was it actually *doing* anything, or just sitting? Perhaps it was
waiting for some other process's lock.
> This is the VACUUM message after cancel
> INFO: --Relation public.unical_ejitem--
> INFO: Pages 416: Changed 0, reaped 396, Empty 0, New 0; Tup 1427: Vac
> 20993, Keep/VTL 0/0, UnUsed 0, MinLen 130, MaxLen 150; Re-using:
> Free/Avail. Space 3102472/3101520; EndEmpty/Avail. Pages 0/397.
> CPU 0.02s/0.00u sec elapsed 3.48 sec.
Hmm ... VACUUM hasn't printed messages that looked like that since 7.3
... you might want to think about an update sometime.
regards, tom lane