Is that VACUUM normal ?

Hi all,

3 hours ago I started :

myplace# vacuum verbose analyze gains;
NOTICE:  --Relation gains--
NOTICE:  Pages 44547: Changed 406, reaped 1941, Empty 0, New 0; Tup 4099959: Vac
 61464, Keep/VTL 0/0, Crash 2, UnUsed 1281, MinLen 67, MaxLen 267; Re-using: Fre
e/Avail. Space 6900268/6899660; EndEmpty/Avail. Pages 0/1917. CPU 8.71s/23.58u s
ec.
NOTICE:  Index ix_gains_idmembreidcondition: Pages 18532; Tuples 4099959: Delete
d 10846. CPU 3.09s/4.39u sec.
NOTICE:  Index actegen_gains_key: Pages 10291; Tuples 4099959: Deleted 10845. CP
U 1.98s/4.11u sec.
NOTICE:  Index idcondition_gains_key: Pages 8420; Tuples 4099959: Deleted 10845.
 CPU 1.93s/4.14u sec.
NOTICE:  Index dategain_gains_key: Pages 15090; Tuples 4099959: Deleted 10845. C
PU 3.46s/4.18u sec.
NOTICE:  Index gains_idgain_key: Pages 10124; Tuples 4099959: Deleted 10845. CPU
 2.33s/4.11u sec.

and now it's stuck here for more than 2 hours now, top says :

  PID USER     PRI  NI  SIZE  RSS SHARE STAT %CPU %MEM   TIME COMMAND
 9790 postgres  16   0 19628  19M 18536 R    99,2  2,0 212:15 postmaster


I use PG 7.03 on a 2x PIII-800 with 1Gb RAM with UWSCSI disks.

Table is about 4M tuples (as you can see), data file is :
-rw-------    1 postgres postgres 364929024 fév 20 08:15 /usr/local/pgsql/data/base/mybase/gains

It shouldn't be THAT long ! I think a few days ago it was 10mn long

Our site is down until I either :
- stop the vacuum but then with no analysis information what will be
the performances ?
- wait until it finishes but what year will that be ?

Anyone has an idea of what's going on ?

--
Jean-Christophe Boggio
cat@thefreecat.org
Independant Consultant and Developer
Delphi, Linux, Perl, PostgreSQL