Postgres Pro
Downloads
Home   >   mailing lists

PostgreSQL VACCUM killing CPU - Mailing list pgsql-performance

From blender@jaskom.pl
Subject PostgreSQL VACCUM killing CPU
Date
Msg-id 1147167570.494108.284720@i39g2000cwa.googlegroups.com
Whole thread Raw
Responses Re: PostgreSQL VACCUM killing CPU  (Will Reese <wreese@rackspace.com>)
Re: PostgreSQL VACCUM killing CPU  (Wu Fengguang <wfg@mail.ustc.edu.cn>)
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: Mitchell Skinner
Date:
Subject: Re: [HACKERS] Big IN() clauses etc : feature proposal
Next
From: "Shoaib Burq"
Date:
Subject: UNSUBSCRIBE