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@xxxxxxxxxxxxxxx>
To: "Rafael Montoya" <rafo-mm@xxxxxxxxxxx>
CC: pgsql-general@xxxxxxxxxxxxxx
Subject: Re: 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/
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
