500 requests per second

From: Tarhon-Onu Victor <mituc(at)iasi(dot)rdsnet(dot)ro>
To: pgsql-performance(at)postgresql(dot)org
Subject: 500 requests per second
Date: 2007-05-12 06:43:25
Message-ID: Pine.LNX.4.64.0705120936580.29679@oynpxoyhr.vnfv.npgvirzrqvngrpu.pbz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


Hi guys,

I'm looking for a database+hardware solution which should be able
to handle up to 500 requests per second. The requests will consist in:
- single row updates in indexed tables (the WHERE clauses will use
the index(es), the updated column(s) will not be indexed);
- inserts in the same kind of tables;
- selects with approximately the same WHERE clause as the update
statements will use.
So nothing very special about these requests, only about the
throughput.

Can anyone give me an idea about the hardware requirements, type
of
clustering (at postgres level or OS level), and eventually about the OS
(ideally should be Linux) which I could use to get something like this in
place?

Thanks!

--

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Michael van Rooyen 2007-05-12 11:10:12 Kernel cache vs shared_buffers
Previous Message Robert Treat 2007-05-12 03:12:57 Re: Best OS for Postgres 8.2