PasteBin for the vmstat output http://pastebin.com/mpHCW9gt On Wed, Jun 23, 2010 at 8:22 PM, Rajesh Kumar Mallah <mallah.rajesh@xxxxxxxxx> wrote: > Dear List , > > I observe that my postgresql (ver 8.4.2) dedicated server has turned cpu > bound and there is a high load average in the server > 50 usually. > The server has > 2 Quad Core CPUs already and there are 6 or 8 drives in raid 10 , there is > negligable i/o wait. There is 32GB ram and no swapping. > > When i strace processes at random i see lot of lseek (XXX,0,SEEK_END) calls > which i feel were not that frequent before. can any pointers be got > for investigating > the high cpu usage by postgresql processes. > > attached is strace out in strace.txt file (sorry if that was not > allowed, i am not sure) > > vmstat output > > # vmstat 10 > > output. > procs -----------memory---------- ---swap-- -----io---- --system-- > -----cpu----------- > r b swpd free buff cache si so bi bo in > cs us sy id wa st > 13 2 150876 2694612 4804 24915540 1 0 443 203 0 0 > 50 6 39 5 0 > 17 1 150868 3580472 4824 24931312 1 0 1395 803 12951 15403 > 63 11 22 4 0 > 20 5 150868 3369892 4840 24938180 0 0 1948 1827 12691 14542 > 79 13 6 2 0 > 8 0 150868 2771920 4856 24968016 0 0 2680 1254 13890 14329 > 72 11 11 5 0 > 18 2 150864 2454008 4872 24995640 0 0 2530 923 13968 15434 > 63 10 20 7 0 > 45 3 150860 2367760 4888 25011756 0 0 1338 1327 13203 14580 > 71 11 16 3 0 > 5 6 150860 1949212 4904 25033052 0 0 1727 1981 13960 15079 > 73 11 12 5 0 > 27 0 150860 1723104 4920 25049588 0 0 1484 794 13199 13676 > 73 10 13 3 0 > 28 6 150860 1503888 4928 25069724 0 0 1650 981 12625 14867 > 75 9 14 2 0 > 8 3 150860 1807744 4944 25087404 0 0 1521 791 13110 15421 > 69 9 18 4 0 > > Rajesh Kumar Mallah. > Avid/Loyal-PostgreSQL user for (past 10 years) > -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
