[PERFORM] VACUUM killing my CPU
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 regards David ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
[PERFORM] PostgreSQL VACCUM killing CPU
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 ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
