View Single Post

   
  #4 (permalink)  
Old 04-15-2008, 09:34 PM
Tom Lane
 
Posts: n/a
Default Re: VACUUM hanging on PostgreSQL 8.3.1 for larger tables

"Paragon" <lr@pcorp.us> writes:
>> Is it actually *doing* anything, like consuming CPU or I/O -- and if so
>> which? How much does VACUUM VERBOSE print before getting stuck?


> --If I start the
> vacuum verbose ky.ky_edges;
> and monitor vmstat 1 looks like this


Sure looks like a near-idle machine to me :-(.

I think that the vacuum must be stuck on a lock. What other Postgres
processes have you got, and what are they doing?

regards, tom lane

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply With Quote