Re: Hardware requirements - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: Hardware requirements
Date
Msg-id 20050929080520.GB25771@svana.org
Whole thread Raw
In response to Re: Hardware requirements  ("Rafael Montoya" <rafo-mm@hotmail.com>)
List pgsql-general
On Thu, Sep 29, 2005 at 09:20:00AM +0200, Rafael Montoya wrote:
> Ok, there are about 15 concurrent clients inserting and  updating data, and
> 20 concurrent clients only consulting.
> I dont need all data in ram, of course, hehe, but i really have no idea
> what's the minimum of ram for having fast answers for about 2000
> transactions in a day.

2000 transactions a day? We were doing over a million per day a few
years ago on a dual PII-350 with 256MB of RAM. As far as people are
concerned here, that's chicken feed. you might need a little more RAM
for the clients but really...

> Almost all queries need to read  more than 7 or 8 tables each time.
> It will work in a  Windows 2000 Server. I need to know whats the appropiate
> hardware, because im sure its not necessary to buy a powerful server if a
> not so powerful one can have a good performance too. I will really
> appreciate any help.

My suggestion, find a spare server you arn't using, and try it out.
That's the only way to be sure...
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.

Attachment

pgsql-general by date:

Previous
From: Dragan Matić
Date:
Subject: How can I check if my cursor statement is using index
Next
From: Dragan Matić
Date:
Subject: Re: How can I check if my cursor statement is using index