Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id DF23E9FB8C7 for ; Mon, 14 May 2007 06:08:07 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 68982-07 for ; Mon, 14 May 2007 06:08:00 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from mail.metronet.co.uk (mail.metronet.co.uk [213.162.97.75]) by postgresql.org (Postfix) with ESMTP id AB83F9FB7EE for ; Mon, 14 May 2007 06:08:03 -0300 (ADT) Received: from server3.office.archonet.com (84-51-143-99.archon037.adsl.metronet.co.uk [84.51.143.99]) by smtp.metronet.co.uk (MetroNet Mail) with ESMTP id 80DCE143602; Mon, 14 May 2007 10:03:26 +0100 (BST) Received: from [192.168.1.36] (dell36.office.archonet.com [192.168.1.36]) by server3.office.archonet.com (Postfix) with ESMTP id A401927411C; Mon, 14 May 2007 10:03:29 +0100 (BST) Message-ID: <464825DE.3090007@archonet.com> Date: Mon, 14 May 2007 10:03:26 +0100 From: Richard Huxton User-Agent: Thunderbird 2.0.0.0 (X11/20070326) MIME-Version: 1.0 To: Tarhon-Onu Victor Cc: pgsql-performance@postgresql.org Subject: Re: 500 requests per second References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/249 X-Sequence-Number: 24639 Tarhon-Onu Victor wrote: > > Hi guys, > > I'm looking for a database+hardware solution which should be able to > handle up to 500 requests per second. Crucial questions: 1. Is this one client making 500 requests, or 500 clients making one request per second? 2. Do you expect the indexes at least to fit in RAM? -- Richard Huxton Archonet Ltd