I had this problem with 7.0.3, but it cleared up completely with 7.1
W
James Thornton wrote:
>
> Vacuum analyze keeps hanging here...
>
> NOTICE: --Relation referer_log--
> NOTICE: Pages 529: Changed 1, reaped 509, Empty 0, New 0; Tup 24306:
> Vac 43000, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 72, MaxLen 324;
> Re-using: Free/Avail. Space 5205100/5193540; EndEmpty/Avail. Pages
> 0/508. CPU 0.03s/0.11u sec.
> NOTICE: Index referer_log_date_idx: Pages 159; Tuples 24306: Deleted 0.
> CPU 0.01s/0.08u sec.
>
> --
>
> My system....
>
> RedHat 6.2
> PostgreSQL 7.03
>
> PIII 500 MHz, 320 MB memory
>
> - JT
> ________________________________________
> James Thornton, http://jamesthornton.com
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster