500 requests per second

Поиск
Список
Период
Сортировка
От Tarhon-Onu Victor
Тема 500 requests per second
Дата
Msg-id Pine.LNX.4.64.0705120936580.29679@oynpxoyhr.vnfv.npgvirzrqvngrpu.pbz
обсуждение исходный текст
Ответы Re: 500 requests per second  (Richard Huxton <dev@archonet.com>)
Re: 500 requests per second  ("Merlin Moncure" <mmoncure@gmail.com>)
Список 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!

--

В списке pgsql-performance по дате отправления:

Предыдущее
От: Robert Treat
Дата:
Сообщение: Re: Best OS for Postgres 8.2
Следующее
От: "Michael van Rooyen"
Дата:
Сообщение: Kernel cache vs shared_buffers