Quoting Michael Ben-Nes <[EMAIL PROTECTED]>: > Hi All > > Im running a postgres server on IBM machine with 2 Xeon 3G Cpu, 3 GB Mem > and Raid. > > I decide to upgrade my server from dual AMD MP 2400, 2 GB mem and raid > to this machine because lately my queries became slower. > To my surprise the current server is even slower. > If your queries became to run slower execute the following command in postgresql shell.
vacuum full all; The is an external script that could be run fron crontab. It will run vacuum on your database. Look in postgresql contrib package. > After banging my head against the wall for a day or two i noticed that > when the CPU is under heavy load the actual work is small ( divided by > 50% between idle and wait ) > > The OS is Centos Linux 2.4.21 SMP > > Here is a small cut from dstat. it shows the idle and iowait ( sum of 99 > ) and all the other are 1% :( > > ----total-cpu-usage---- > usr sys idl wai hiq siq| > 1 1 93 5 0 0| > 1 0 49 50 0 0| > 1 0 50 49 0 0| > 0 0 50 50 0 0| > 1 0 50 49 0 0| > > Any idea what could be the problem ? > ================== BannerShift - text ad exchange http://www.bannershift.com/text-ad-exchange/ ================================================================= To unsubscribe, send mail to [EMAIL PROTECTED] with the word "unsubscribe" in the message body, e.g., run the command echo unsubscribe | mail [EMAIL PROTECTED]
