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.
pgsql-performance by date
|Next:||From: Kevin Grittner||Date: 2012-04-05 15:41:57|
|Subject: Re: bad planning with 75% effective_cache_size|
|Previous:||From: Kevin Grittner||Date: 2012-04-05 15:34:36|
|Subject: Re: Planner selects slow "Bitmap Heap Scan" when
"Index Scan" is faster|