From: | webb sprague <wsprague(at)o1(dot)com> |
---|---|
To: | James Thornton <james(at)unifiedmind(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Vacuum analyze keeps hanging (RedHat 6.2, PG 7.03) |
Date: | 2001-04-28 20:33:48 |
Message-ID: | 3AEB292C.6C4490B9@o1.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Alfred Perlstein | 2001-04-28 20:43:18 | Re: On the _need_ to vacuum... |
Previous Message | James Thornton | 2001-04-28 20:14:52 | Re: IpcMemoryCreate: shmget failed (Invalid argument) |