Received: from localhost (mx1.hub.org [200.46.208.251])
	by postgresql.org (Postfix) with ESMTP id 6BD479FB322
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Fri,  3 Nov 2006 10:32:31 -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 64366-08 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Fri,  3 Nov 2006 10:32:27 -0400 (AST)
X-Greylist: from auto-whitelisted by SQLgrey-
Received: from DCSG0026.ouro.cydcmail.com.br (smtp-out.ouro.cydcmail.com.br
	[201.24.29.62]) by postgresql.org (Postfix) with ESMTP id 138FC9FB321
	for <pgsql-performance@postgresql.org>;
	Fri,  3 Nov 2006 10:32:26 -0400 (AST)
Received: from brturbo.com.br ([10.160.209.144]) by
 smtp-1.ouro.cydcmail.com.br
	(MSG) with ESMTP id <0J8500A6LPFU2N00@smtp-1.ouro.cydcmail.com.br> for
	pgsql-performance@postgresql.org; Fri, 03 Nov 2006 10:28:42 -0300 (BrT)
Received: from [10.160.208.148] (Forwarded-For: [10.160.208.99])
	by mailstore-1.ouro.cydcmail.com.br (mshttpd);
	Fri, 03 Nov 2006 11:28:36 -0200
Date: Fri, 03 Nov 2006 11:28:36 -0200
From: creimer@brturbo.com.br
Subject: Re: Context switch storm
In-reply-to: <454B3B75.6@archonet.com>
To: Richard Huxton <dev@archonet.com>
Cc: pgsql-performance@postgresql.org
Message-id: <c4069b084d04.454b27e4@brturbo.com.br>
MIME-version: 1.0
X-Mailer: OURO WEBMAIL
Content-type: multipart/alternative;
	boundary="Boundary_(ID_ydw8ctzto5xsztT57mO0sg)"
Content-language: pt
X-Accept-Language: pt
References: <efc1d7c07cf.454afe8d@brturbo.com.br> <454B3B75.6@archonet.com>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.645 tagged_above=0 required=5 tests=BAYES_00,
	DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, HTML_30_40, HTML_MESSAGE,
	NO_REAL_NAME
X-Spam-Level: 
X-Archive-Number: 200611/47
X-Sequence-Number: 21817

This is a multi-part message in MIME format.

--Boundary_(ID_ydw8ctzto5xsztT57mO0sg)
Content-type: text/plain; charset=us-ascii
Content-transfer-encoding: 7BIT
Content-disposition: inline

> If you can keep your numbers of clients down below the critical 
> level, 
> you should find the overall workload is fine. 

We have at about 600 connections. Is this a case to use a connection pool (pg_pool) system?
 
And why this happens only with 8.0 and 8.1 and not with the 7.4?

--Boundary_(ID_ydw8ctzto5xsztT57mO0sg)
Content-type: text/html; charset=us-ascii
Content-transfer-encoding: 7BIT
Content-disposition: inline

<DIV>&gt; If you can keep your numbers of clients down below the critical <BR>&gt; level, <BR>&gt; you should find the overall workload is fine. </DIV>
<DIV>&nbsp;</DIV>
<DIV>
<DIV>We have at about 600 connections. Is this a case to use a connection pool (pg_pool) system?</DIV>
<DIV>&nbsp;</DIV>
<DIV>And why this happens only with 8.0 and 8.1 and not with the 7.4?</DIV>
<DIV>&nbsp;</DIV>
<DIV>&nbsp;</DIV></DIV>

--Boundary_(ID_ydw8ctzto5xsztT57mO0sg)--