Vacuum analyze keeps hanging (RedHat 6.2, PG 7.03)

From: James Thornton <james(at)unifiedmind(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Vacuum analyze keeps hanging (RedHat 6.2, PG 7.03)
Date: 2001-04-28 04:00:31
Message-ID: 3AEA405F.77204D38@unifiedmind.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Anzo 2001-04-28 04:22:11 Re: how to migrate from SQL Server7 to PostgreSQL7??
Previous Message Jack Bates 2001-04-28 03:33:57 On the _need_ to vacuum...