On Thu, Apr 5, 2012 at 11:39 AM, Gregg Jaskiewicz <gryz...@gmail.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 -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
