Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from
	<pgsql-performance-owner+M49387=pgsql-performance-ar@postgresql.org>)
	id 1UCW2W-00086l-1L for pgsql-performance@arkaria.postgresql.org;
	Mon, 04 Mar 2013 14:06:52 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
	by malur.postgresql.org with smtp (Exim 4.72) (envelope-from
	<pgsql-performance-owner+M49387=pgsql-performance-ar@postgresql.org>)
	id 1UCW2V-0006bf-2S for pgsql-performance@arkaria.postgresql.org;
	Mon, 04 Mar 2013 14:06:51 +0000
Received: from makus.postgresql.org ([2001:4800:7903:4::125])
	by malur.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <aweber@comcast.net>) id 1UCW2R-0006YY-DR
	for pgsql-performance@postgresql.org; Mon, 04 Mar 2013 14:06:47 +0000
Received: from qmta02.westchester.pa.mail.comcast.net
	([2001:558:fe14:43:76:96:62:24])
	by makus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <aweber@comcast.net>) id 1UCW2P-0007NA-6D
	for pgsql-performance@postgresql.org; Mon, 04 Mar 2013 14:06:45 +0000
Received: from omta18.westchester.pa.mail.comcast.net ([76.96.62.90])
	by qmta02.westchester.pa.mail.comcast.net with comcast
	id 7PlX1l0071wpRvQ51S6jbB; Mon, 04 Mar 2013 14:06:43 +0000
Received: from [192.168.1.176] ([69.142.185.164])
	by omta18.westchester.pa.mail.comcast.net with comcast
	id 7S6i1l00i3ZEZL53eS6jF1; Mon, 04 Mar 2013 14:06:43 +0000
Message-ID: <5134AA00.6080800@comcast.net>
Date: Mon, 04 Mar 2013 09:04:48 -0500
From: AJ Weber <aweber@comcast.net>
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64;
	rv:7.0.1) Gecko/20110929 Thunderbird/7.0.1
MIME-Version: 1.0
To: pgsql-performance@postgresql.org
Subject: Re: What setup would you choose for postgresql 9.2 installation?
References: <31E8EC2A-72E9-419A-9CDD-5B646A534272@autouncle.com>
In-Reply-To: <31E8EC2A-72E9-419A-9CDD-5B646A534272@autouncle.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=comcast.net;
	s=q20121106; t=1362406003;
	bh=6kb7ioUe4bjWCIVXtfm+FEbXCT2Ec1E/cj4we/NVKII=;
	h=Received:Received:Message-ID:Date:From:MIME-Version:To:Subject:
	Content-Type;
	b=CbYdjFmF7hhFAvsFPMZB3jkdzPMVUom/uYnl/fqNWqKuiLXHTC3IV0TYH3fADdcsI
	ar2oFOMHgZOGQ/4A1L5x8FTDDAMCt+fsXUh78MsLYqpMgHArbhOvwqurrRbc3TBNfH
	KPzYqFDM1+0WrQfqEZFwR578ljhPkJciwtDwd2j6R6kypxxAX8JktFEzv4x7vcJ/0Z
	Pc5WNXAXXWgRMKwwfbpXOxPbl5w0Z+DKjl49zzq0lyTkuH791ip1BkbKa7Buo6Ts4t
	LzapVWpdGmu80OW76WCKJXDsWG/JzhRmHzPbYya3PSX9RI5liqfrud0TwtG34ncLwV
	K3prXOoxJkrkA==
X-Pg-Spam-Score: -2.5 (--)
List-Archive: <http://archives.postgresql.org/pgsql-performance>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-performance.postgresql.org>
List-Owner: <mailto:pgsql-performance-owner@postgresql.org>
List-Post: <mailto:pgsql-performance@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-performance>
List-Unsubscribe: 
 <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
X-Mailing-List: pgsql-performance
Precedence: bulk
Sender: pgsql-performance-owner@postgresql.org

Apologies for the tangential question, but how would pgpool2 "increase 
throughput"?  Wouldn't the same number of statements be issued by your 
application?  It would likely reduce the number of concurrent 
connections, but that doesn't necessarily equate to "increased throughput".

-AJ


On 3/4/2013 8:52 AM, Niels Kristian Schjødt wrote:
> LSI MegaRAID SAS 9260-4i with four Intel SSDSC2CW240A3K5 SSDs OR four Hitachi Ultrastar 15K600 SAS drives?
>
> My app is pretty write heavy and I have a lot of concurrent connections 300 - (though considering adding pgpool2 in front to increase throughput).
>
> Regards Niels Kristian
>


-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance