Vacuum analyze keeps hanging (RedHat 6.2, PG 7.03) - Mailing list pgsql-general

From James Thornton
Subject Vacuum analyze keeps hanging (RedHat 6.2, PG 7.03)
Date
Msg-id 3AEA405F.77204D38@unifiedmind.com
Whole thread Raw
List pgsql-general
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




pgsql-general by date:

Previous
From: Sterling
Date:
Subject: Re: SQL Where Like - Range it?!
Next
From: Harry Yau
Date:
Subject: function with multi-values