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 waiti
Hi all !
I am running PostgreSQL 7.3.2 on Linux 2.6.13...
What I see when VACUUM process is running is:
Cpu(s): 0.0% us, 3.2% sy, 0.0% ni, 0.0% id, 93.5% wa, 3.2% hi,
0.0% si
What I am worry about is "93.5% wa" ...
Could someone explain me what is the VACUUM process waiting for ?
Best re