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

From webb sprague
Subject Re: Vacuum analyze keeps hanging (RedHat 6.2, PG 7.03)
Date
Msg-id 3AEB292C.6C4490B9@o1.com
Whole thread Raw
In response to Vacuum analyze keeps hanging (RedHat 6.2, PG 7.03)  (James Thornton <james@unifiedmind.com>)
List 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

pgsql-general by date:

Previous
From: Brook Milligan
Date:
Subject: Re: [HACKERS] While we're on the subject of searches...
Next
From: "Erich K. Oliphant"
Date:
Subject: VACUUMing in general