Re: Hardware requirements - Mailing list pgsql-general

From Rafael Montoya
Subject Re: Hardware requirements
Date
Msg-id BAY18-F31273484D8F0ABDFDCE372F88C0@phx.gbl
Whole thread Raw
In response to Re: Hardware requirements  (Ben <bench@silentmedia.com>)
Responses Re: Hardware requirements
Re: Hardware requirements
List pgsql-general
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.
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.
Rafael Montoya


>From: Ben <bench@silentmedia.com>
>To: "Rafael Montoya" <rafo-mm@hotmail.com>
>CC: pgsql-general@postgresql.org
>Subject: Re: [GENERAL] Hardware requirements
>Date: Wed, 28 Sep 2005 23:30:06 -0700
>
>Unless you need all that data in ram (and you probably don't), then  any
>machine should be capable. The real questions are, how many  concurrent
>clients? How static is the data? What is your query  complexity?
>
>On Sep 28, 2005, at 11:08 PM, Rafael Montoya wrote:
>
>>Hello everybody, i really need to know hardware requirements for
>>installing PostgreSQL 8.0.3.
>>I'm in a database migration project and it is important to work  with the
>>appropiate hardware.
>>DB must work in windows. There are 50 tables aprox and data size is  near
>>6 GB. Thank for your answers.
>>Rafael Montoya
>>
>>_________________________________________________________________
>>Dale rienda suelta a tu tiempo libre. Encuentra mil ideas para  exprimir
>>tu ocio con MSN Entretenimiento. http:// entretenimiento.msn.es/
>>
>>
>>---------------------------(end of  broadcast)---------------------------
>>TIP 5: don't forget to increase your free space map settings
>>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 6: explain analyze is your friend

_________________________________________________________________
Descubre la descarga digital con MSN Music. Más de medio millón de
canciones. http://music.msn.es/


pgsql-general by date:

Previous
From: Ben
Date:
Subject: Re: Hardware requirements
Next
From: "Partners - Majolee InfoTech"
Date:
Subject: pg_restore error