Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group