Re: heavly load system spec

On Thu, Apr 5, 2012 at 11:39 AM, Gregg Jaskiewicz <gryzman(at)gmail(dot)com> wrote:
> I know this is a very general question. But if you guys had to specify
> system (could be one server or cluster), with sustainable transaction
> rate of 1.5M tps running postgresql, what configuration and hardware
> would you be looking for ?
> The transaction distribution there is 90% writes/updates and 10% reads.
> We're talking 64 linux, Intel/IBM system.
>
> I'm trying to see how that compares with Oracle system.

1.5 million is a lot of tps, especially if some of them are write
transactions. On trivial read-only transactions (primary key lookup
on fully cached table), using a 16-core, 64-thread IBM POWER7 box,
pgbench -M prepared -S -n -T 60 -c 64 -j 64:

tps = 455903.743918 (including connections establishing)
tps = 456012.871764 (excluding connections establishing)

That box isn't quite the fastest one I've seen, but it's close.

What hardware is Oracle running on?

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company