Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id E4E9563221C for ; Thu, 27 May 2010 04:27:52 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 60426-10 for ; Thu, 27 May 2010 07:27:45 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-pv0-f174.google.com (mail-pv0-f174.google.com [74.125.83.174]) by mail.postgresql.org (Postfix) with ESMTP id 4257962D9D2 for ; Thu, 27 May 2010 04:27:45 -0300 (ADT) Received: by pvg3 with SMTP id 3so1514180pvg.19 for ; Thu, 27 May 2010 00:27:43 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:from:to:subject:date :message-id:mime-version:content-type:x-mailer:thread-index :x-mimeole; bh=TQJq/G43Bkurl1su/Twd5dGcFVGfBIzCue+B0/E4DVQ=; b=joSgaw+5Hs8FlhkiV1kdqLSPBFFYXKDrRxVE5PuH2ShOn/DsKH/h4eI9BZSHi9yi2f uhR+/dhQJIo7Pk2ahhaKlvFnQ1ddQZ8mnDaaY3E/IreNk2AvKfQHSTJ2NqIMlkJ8Qr5f Hwy3kE2XVQtLn6uWrnNJT0lTFg8dnjkGaOr0U= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=from:to:subject:date:message-id:mime-version:content-type:x-mailer :thread-index:x-mimeole; b=j7GDjw9kysH/v2RMORjkza/BICyNxy/50Gl7KlQ/aDVv1rx6v49vtrF/viDPXCDRwT zeAHXdTZBpkXMJKEo/PUHI3bUvsaZGUJf3ZnvimPjUiTsazjL/nmYu+K7j85R5LFP2H7 +f0tfcoCk5nU/ANJIcTLIpj8S4qREFKoXARiM= Received: by 10.140.55.13 with SMTP id d13mr7507099rva.119.1274945263537; Thu, 27 May 2010 00:27:43 -0700 (PDT) Received: from NECSLGZ0061411 (mx.gtmc.com.cn [58.62.17.14]) by mx.google.com with ESMTPS id h11sm811633rvm.9.2010.05.27.00.27.41 (version=SSLv3 cipher=RC4-MD5); Thu, 27 May 2010 00:27:42 -0700 (PDT) From: =?gb2312?B?u8bTwM7A?= To: , Subject: About Tom Lane's Xeon CS test case Date: Thu, 27 May 2010 15:27:41 +0800 Message-ID: <3859ECB0DC6F4B028448795941712CE0@NECSLGZ0061411> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_001E_01CAFDB1.271692F0" X-Mailer: Microsoft Office Outlook 11 Thread-Index: Acr9bNctKo3gWGhCS1SihGC6cgG7AgAAS7iA X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5931 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.782 tagged_above=-10 required=5 tests=BAYES_50=0.8, HTML_FONT_FACE_BAD=0.981, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_NONE=-0.0001 X-Spam-Level: * X-Archive-Number: 201005/224 X-Sequence-Number: 38808 This is a multi-part message in MIME format. ------=_NextPart_000_001E_01CAFDB1.271692F0 Content-Type: text/plain; charset="gb2312" Content-Transfer-Encoding: quoted-printable Dear all and Tom=A3=AC Recently my company=A1=AFs postgres DB server sluggish suddenly = with a hight Context-switching value as below: =20 2010-04-07 04:03:15 procs memory swap = io system cpu 2010-04-07 04:03:15 r b swpd free buff cache si so bi = bo in cs us sy id wa 2010-04-07 14:04:27 3 0 0 2361272 272684 3096148 0 0 3 1445 973 14230 7 8 84 0 2010-04-07 14:05:27 2 0 0 2361092 272684 3096220 0 0 3 1804 1029 31852 8 10 81 1 2010-04-07 14:06:27 1 0 0 2362236 272684 3096564 0 0 3 1865 1135 19689 9 9 81 0 2010-04-07 14:07:27 1 0 0 2348400 272720 3101836 0 0 3 1582 1182 149461 15 17 67 0 2010-04-07 14:08:27 3 0 0 2392028 272840 3107600 0 0 3 3093 1275 203196 24 23 53 1 2010-04-07 14:09:27 3 1 0 2386224 272916 3107960 0 0 3 2486 1331 193299 26 22 52 0 2010-04-07 14:10:27 34 0 0 2332320 272980 3107944 0 0 3 1692 1082 214309 24 22 54 0 2010-04-07 14:11:27 1 0 0 2407432 273028 3108092 0 0 6 2770 1540 76643 29 13 57 1 2010-04-07 14:12:27 9 0 0 2358968 273104 3108388 0 0 7 2639 1466 10603 22 6 72 1 =20 =20 I have read this problem about =A1=B0=A1=B0Tom Lane=A1=B1 = Workload=A1=B1 . And I found my company=A1=AFs DB is a Xeon MP server. I am going to have a test to confirm it. =20 If anybody have the test case =A1=B0Tom Lane's Xeon CS test case=A1=B1 ? = =20 Thank you! =20 =20 My postgres version: 8.1.3;=20 My OS version: Linux version 2.4.21-47.Elsmp((Red Hat Linux 3.2.3-54) My CPU: processor : 7 vendor_id : GenuineIntel cpu family : 15 model : 6 model name : Intel(R) Xeon(TM) CPU 3.40GHz stepping : 8 cpu MHz : 3400.262 cache size : 1024 KB physical id : 1 =20 =20 =20 Best regards, Ray Huang ------=_NextPart_000_001E_01CAFDB1.271692F0 Content-Type: text/html; charset="gb2312" Content-Transfer-Encoding: quoted-printable

Dear all = and Tom=A3=AC

    Recently my = company=A1=AFs  postgres DB server sluggish suddenly = with a hight Context-switching value as below:

 

2010-04-07 04:03:15 procs           &n= bsp;          memory      swap          io =     system       &= nbsp; cpu

2010-04-07 04:03:15  r  b   swpd   free   buff  cache   si   so    = bi    bo   in    cs us sy id = wa

2010-04-07 14:04:27  3  0      0 2361272 272684 3096148    0    0     = 3  1445  973 14230  7  8 84  = 0

2010-04-07 14:05:27  2  0      0 2361092 272684 3096220    0    0     = 3  1804 1029 31852  8 10 81  1

2010-04-07 14:06:27  1  0      0 2362236 272684 3096564    0    0     = 3  1865 1135 19689  9  9 81  0

2010-04-07 14:07:27  1  0      0 2348400 272720 3101836    0    0     = 3  1582 1182 149461 15 17 67  0

2010-04-07 14:08:27  3  0      0 2392028 272840 3107600    0    0     = 3  3093 1275 203196 24 23 53  1

2010-04-07 14:09:27  3  1      0 2386224 272916 3107960    0    0     = 3  2486 1331 193299 26 22 52  0

2010-04-07 14:10:27 34  0      0 2332320 272980 = 3107944    0    0     3  1692 1082 214309 = 24 22 54  0

2010-04-07 14:11:27  1  0      0 2407432 273028 3108092    0    0     = 6  2770 1540 76643 29 13 57  1

2010-04-07 14:12:27  9  0      0 2358968 273104 3108388    0    0     = 7  2639 1466 10603 22  6 72  1

 

 

    I have read this problem  about =A1=B0=A1=B0Tom = Lane=A1=B1 Workload=A1=B1 = . And I found my company=A1=AFs DB  is a Xeon MP = server.

I am going to have a test to confirm it.

 

If anybody have the test case =A1=B0Tom Lane's Xeon CS test case=A1=B1 ?  =

Thank you!

    =

 

My postgres version: 8.1.3; =

My OS version: Linux version 2.4.21-47.Elsmp((Red Hat Linux 3.2.3-54)

My CPU:

processor       : 7

vendor_id       : GenuineIntel

cpu family      : 15

model       = ;    : 6

model name      : Intel(R) Xeon(TM) CPU = 3.40GHz

stepping      &n= bsp; : 8

cpu MHz         : = 3400.262

cache size      : 1024 = KB

physical id     : 1

 

 = ;

 

=

Best = regards,

Ray = Huang

------=_NextPart_000_001E_01CAFDB1.271692F0--