From: Sebastian Lallana <slallana@datatransfer.com.ar>
To: pgsql-performance@postgresql.org
Subject: FW: Tx forecast improving harware capabilities.
Date: Thu, 18 Aug 2005 12:01:24 -0300
Message-ID: <722B1B9CFE0ECE488342E3EC2BA920B86CC443@mailserver> (raw)
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: slallana@datatransfer.com.ar
Subject: Re: FW: Tx forecast improving harware capabilities.
In-Reply-To: <722B1B9CFE0ECE488342E3EC2BA920B86CC443@mailserver>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox