X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 1F95D529CC for ; Thu, 18 Aug 2005 12:01:26 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 03401-02 for ; Thu, 18 Aug 2005 15:01:20 +0000 (GMT) Received: from urano.datatransfer.com.ar (host202.200.80.31.ifxnw.com.ar [200.80.31.202]) by svr1.postgresql.org (Postfix) with ESMTP id D259B52984 for ; Thu, 18 Aug 2005 12:01:16 -0300 (ADT) Content-Class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C5A405.B3701AEC" Subject: FW: Tx forecast improving harware capabilities. X-MimeOLE: Produced By Microsoft Exchange V6.0.6556.0 Date: Thu, 18 Aug 2005 12:01:24 -0300 Message-ID: <722B1B9CFE0ECE488342E3EC2BA920B86CC443@mailserver> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Tx forecast improving harware capabilities. thread-index: AcWjb2iCgsLuHIzSSjO5/yF8LaVzUQAiVH5AAAMSZgA= From: "Sebastian Lallana" To: X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.051 required=5 tests=[FORGED_RCVD_HELO=0.05, HTML_MESSAGE=0.001] X-Spam-Level: X-Archive-Number: 200508/229 X-Sequence-Number: 13976 This is a multi-part message in MIME format. ------_=_NextPart_001_01C5A405.B3701AEC Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Hello: We are having serious performance problems using JBOSS and PGSQL. I'm sure the problem has to do with the application itself (and neither with JBOSS nor PGSQL) but the fact is that we are using desktop equipment to run both Jboss and Postgresql (An Athlon 2600, 1 Gb Ram, IDE HDD with 60 Mb/sec Transfer Rate), and the answers arise: If we upgrade our hardware to a Dual Processor would the transactions per second increase significantly? Would Postgresql take advantage from SMP? Presumably yes, but can we do a forecast about the number of tps? What we need is a paper with some figures showing the expected performance in different environments. Some study about the "degree of correlation" between TPS and Number of Processors, Cache, Frequency, Word Size, Architecture, etc.=20 It exists something like this? Does anybody has experience about this subject? =20 Thanks in advance and best regards. =20 P.S. I've been looking at www.tpc.org but I could't find anything valuable. =20 =20 ------_=_NextPart_001_01C5A405.B3701AEC Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Hello:

We are having serious performance problems = using JBOSS and PGSQL.

I’m sure the problem has to do with the application itself (and neither with JBOSS nor PGSQL) but the fact is that we are using = desktop equipment to run both Jboss and Postgresql (An = Athlon 2600, 1 Gb Ram, IDE HDD with 60 Mb/sec Transfer Rate), and the answers = arise:

If we upgrade our hardware to a Dual Processor = would the transactions per second increase significantly? Would Postgresql take advantage from SMP? = Presumably yes, but can we do a forecast about the number of tps? What we need is a = paper with some figures showing the expected performance in different environments. = Some study about the “degree of correlation” between TPS and = Number of Processors, Cache, Frequency, Word Size, Architecture, etc. =

It exists = something like this? Does anybody has experience about this subject?

 =

Thanks in advance and best regards.

 =

P.S. I’ve = been looking at www.tpc.org but I could’t find anything valuable.  =

 =

------_=_NextPart_001_01C5A405.B3701AEC--