Re: 500 requests per second

From: PFC <lists(at)peufeu(dot)com>
To: "Merlin Moncure" <mmoncure(at)gmail(dot)com>, "Tarhon-Onu Victor" <mituc(at)iasi(dot)rdsnet(dot)ro>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: 500 requests per second
Date: 2007-05-21 20:48:04
Message-ID: op.tso2qemxcigqcu@apollo13
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


>> I'm looking for a database+hardware solution which should be
>> able to handle up to 500 requests per second.

What proportion of reads and writes in those 500 tps ?
(If you have 450 selects and 50 inserts/update transactions, your
hardware requirements will be different than those for the reverse
proportion)

What is the estimated size of your data and hot working set ?

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Jim C. Nasby 2007-05-21 21:01:25 Re: Postgres Benchmark Results
Previous Message Jim C. Nasby 2007-05-21 20:46:55 Re: 500 requests per second