PostgreSQL VACCUM killing CPU

From: blender(at)jaskom(dot)pl
To: pgsql-performance(at)postgresql(dot)org
Subject: PostgreSQL VACCUM killing CPU
Date: 2006-05-09 10:19:08
Message-ID: 1147167570.494108.284720@i39g2000cwa.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hi all !

I have got such problem.
Im running Postgresql 7.3.2 on Linux 2.6.13.
What is see when VACCUM is running and killing my CPU is:

Cpu(s): 3.2% us, 0.0% sy, 0.0% ni, 0.0% id, 96.8% wa, 0.0% hi,
0.0% si

what i am worry about is "96.8% wa" why is it like that?

what is the process waiting for ?

could somone explain me that please? :)

Best regards
david

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Hannes Dorbath 2006-05-09 10:24:30 Re: Arguments Pro/Contra Software Raid
Previous Message PFC 2006-05-09 10:10:37 Re: [HACKERS] Big IN() clauses etc : feature proposal