pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: PFC <lists@peufeu.com>
To: Merlin Moncure <mmoncure@gmail.com>
To: Tarhon-Onu Victor <mituc@iasi.rdsnet.ro>
Cc: pgsql-performance@postgresql.org
Subject: Re: 500 requests per second
Date: Mon, 21 May 2007 22:48:04 +0200
Message-ID: <op.tso2qemxcigqcu@apollo13> (raw)
In-Reply-To: <b42b73150705211250w61f9737ele7c498d8e1517ed3@mail.gmail.com>
References: <Pine.LNX.4.64.0705120936580.29679@oynpxoyhr.vnfv.npgvirzrqvngrpu.pbz>
	<b42b73150705211250w61f9737ele7c498d8e1517ed3@mail.gmail.com>


>>         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 ?



view thread (9+ messages)  latest in thread

Message-ID: <op.tso2qemxcigqcu@apollo13>
Permalink:  ../op.tso2qemxcigqcu@apollo13/
Also on:    postgresql.org/message-id/op.tso2qemxcigqcu@apollo13

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: lists@peufeu.com, mmoncure@gmail.com, mituc@iasi.rdsnet.ro
  Subject: Re: 500 requests per second
  In-Reply-To: <op.tso2qemxcigqcu@apollo13>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox