pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Most transactions per second on largest box?
2+ messages / 2 participants
[nested] [flat]

* Most transactions per second on largest box?
@ 2004-06-03 23:10 jason.servetar@ccgenesis.com
  2004-06-04 05:57 ` Re: Most transactions per second on largest box? Greg Stark <gsstark@mit.edu>
  0 siblings, 1 reply; 2+ messages in thread

From: jason.servetar@ccgenesis.com @ 2004-06-03 23:10 UTC (permalink / raw)
  To: pgsql-performance

This is a very general question but what is the largest linux box anyone
has run PostgreSQL on and what kind of concurrent transactions per
second have you seen? 

 

We have a client who has huge bursts of activity, coinciding with high
rated TV appearances, meaning hundreds of thousands of users registering
and logging in at the same time.

 

Currently we are running a dual cpu dell blade server on redhat linux
(2.4?) and PostgreSQL 7.3.4 on i686-pc-linux-gnu, compiled by GCC 2.96,
raid5 and am using sqlrelay for connection pooling.  It works fine under
ordinary load but bogs down too much under these huge loads. 

 

I would love to be able to tell them that a specific box like a 2 ghz
quad xenon with 10 GB of ram, on a raid 10 server will get them x
concurrent transactions per second with x threads running. From that I
can give them a great estimate on how many registrations per minute
there money can buy, but right now all I can tell them is that if you
spend more money you will get more tps. 

 

Thanks for any info you may have. 

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Most transactions per second on largest box?
  2004-06-03 23:10 Most transactions per second on largest box? jason.servetar@ccgenesis.com
@ 2004-06-04 05:57 ` Greg Stark <gsstark@mit.edu>
  0 siblings, 0 replies; 2+ messages in thread

From: Greg Stark @ 2004-06-04 05:57 UTC (permalink / raw)
  To: jason.servetar@ccgenesis.com; +Cc: pgsql-performance


<jason.servetar@ccgenesis.com> writes:

> Currently we are running a dual cpu dell blade server on redhat linux
> (2.4?) and PostgreSQL 7.3.4 on i686-pc-linux-gnu, compiled by GCC 2.96,
> raid5 and am using sqlrelay for connection pooling.  It works fine under
> ordinary load but bogs down too much under these huge loads. 

I can't answer the question you asked. But I would suggest you upgrade your
compiler. 2.96 is just about the worst version of gcc to be using for
anything. It has known bugs where it just flatly miscompiles code, resulting
in programs that crash or behave strangely.

Also postgresql 7.4 has lots of very nice performance improvements including
everyone's favourite, "IN" optimization. So you might consider upgrading to
7.4.2.

> I would love to be able to tell them that a specific box like a 2 ghz
> quad xenon with 10 GB of ram, on a raid 10 server will get them x
> concurrent transactions per second with x threads running. From that I
> can give them a great estimate on how many registrations per minute
> there money can buy, but right now all I can tell them is that if you
> spend more money you will get more tps. 

Unfortunately nobody will be able to give you precise numbers since it will
depend a *lot* on the precise queries and database design you're working with.
There are also a lot of variables in the hardware design where you trade off
increasing cpus vs improving the disk subsystem and such.

You're going to have to do some performance testing of your application on
different hardware and extrapolate from that. Unfortunately (or fortunately
depending on your billing model:) this can be a lot of work. It involves
setting up a database with a realistic quantity of data, and some sort of test
harness simulating users.

In general terms though, several people have mentioned being happy with
Opteron servers, and generally people find spending money on good hardware
RAID cards with battery backed caches and more disks to spread data over to be
more effective than spending money on more or faster processors.

If you benchmark your application on a given set of hardware and analyze where
your bottleneck is then people may be able to suggest what alternatives to
consider and may be able to give some idea of what type of improvement to
expect. But it takes actual data from vmstat, iostat, et al to do this
analysis.

-- 
greg




^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2004-06-04 05:57 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-06-03 23:10 Most transactions per second on largest box? jason.servetar@ccgenesis.com
2004-06-04 05:57 ` Greg Stark <gsstark@mit.edu>

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