heavly load system spec

From: Gregg Jaskiewicz <gryzman(at)gmail(dot)com>
To: postgres performance list <pgsql-performance(at)postgresql(dot)org>
Subject: heavly load system spec
Date: 2012-04-05 15:39:26
Message-ID: CAJY59_jeC1r5LYOk05UiL5BE+C=WQAVD17+LU93q2CLSvh4Umg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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.

Thanks.

--
GJ

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Kevin Grittner 2012-04-05 15:41:57 Re: bad planning with 75% effective_cache_size
Previous Message Kevin Grittner 2012-04-05 15:34:36 Re: Planner selects slow "Bitmap Heap Scan" when "Index Scan" is faster