Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 697C79FA372 for ; Mon, 6 Nov 2006 15:29:05 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 24373-06 for ; Mon, 6 Nov 2006 15:28:57 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from server.linux27.com (server.linux27.com [72.232.77.42]) by postgresql.org (Postfix) with ESMTP id 4A68B9FA103 for ; Mon, 6 Nov 2006 15:28:57 -0400 (AST) Received: from [201.67.132.199] (port=15860 helo=PC1) by server.linux27.com with esmtpa (Exim 4.52) id 1GhA9O-0001ka-7C; Mon, 06 Nov 2006 17:28:55 -0200 Reply-To: From: "Carlos H. Reimer" To: , Subject: RES: Context switching Date: Mon, 6 Nov 2006 16:29:13 -0200 Message-ID: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0063_01C701C0.B2389630" X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0) In-Reply-To: Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2962 X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - server.linux27.com X-AntiAbuse: Original Domain - postgresql.org X-AntiAbuse: Originator/Caller UID/GID - [0 0] / [47 12] X-AntiAbuse: Sender Address Domain - opendb.com.br X-Source: X-Source-Args: X-Source-Dir: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200611/71 X-Sequence-Number: 21841 This is a multi-part message in MIME format. ------=_NextPart_000_0063_01C701C0.B2389630 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit Hi, Sorry, but this message was already post some days before! Thank you! Carlos -----Mensagem original----- De: pgsql-performance-owner@postgresql.org [mailto:pgsql-performance-owner@postgresql.org]Em nome de Carlos H. Reimer Enviada em: quarta-feira, 1 de novembro de 2006 03:23 Para: pgsql-performance@postgresql.org Assunto: [PERFORM] Context switching Hi, We've migrated one of our servers from pg 7.4 to 8.1 and from times to times (4 hours) the server start doing a lot of context switching and all transactions become very slow. The average context switching for this server as vmstat shows is 1 but when the problem occurs it goes to 250000. CPU and memory usage are ok. What can produce this context switching storms? It is a box with 12GB RAM and 4 processors running RedHat Enterprise Linux AS. Thank you in advance! Reimer carlos.reimer@opendb.com.br OpenDB Serviços e Treinamentos PostgreSQL e DB2 Fone: 47 3327-0878 Cel: 47 9602-0151 www.opendb.com.br ------=_NextPart_000_0063_01C701C0.B2389630 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hi,
 
Sorry, but this=20 message was already post some days before!
 
Thank = you!
 
Carlos
 
-----Mensagem = original-----
De:=20 pgsql-performance-owner@postgresql.org=20 [mailto:pgsql-performance-owner@postgresql.org]Em nome de Carlos = H.=20 Reimer
Enviada em: quarta-feira, 1 de novembro de 2006=20 03:23
Para: = pgsql-performance@postgresql.org
Assunto:=20 [PERFORM] Context switching

Hi,
 
We've migrated=20 one of our servers from pg 7.4 to 8.1 and from times to times (4 = hours) the=20 server start doing a lot of context switching and all transactions = become very=20 slow.
 
The = average=20 context switching for this server as vmstat shows is 1 but when the = problem=20 occurs it goes to 250000.
 
CPU = and memory=20 usage are ok.
 
What can produce=20 this context switching storms?
 
It = is a box with=20 12GB RAM and 4 processors running RedHat Enterprise Linux=20 AS.
 
Thank you in=20 advance!

Reimer
carlos.reimer@opendb.com.brOpenDB=20 Servi=E7os e Treinamentos PostgreSQL e DB2
Fone: 47 3327-0878 Cel: = 47=20 9602-0151
www.opendb.com.br

 
------=_NextPart_000_0063_01C701C0.B2389630--