Обсуждение: Hardware requirements
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/
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 >
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/
am 29.09.2005, um 9:20:00 +0200 mailte Rafael Montoya folgendes: > 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. Substitute 'Windows 2000 Server' with 'Linux', so you can save money and you can more money spend in RAM. Regards, Andreas -- Andreas Kretschmer (Kontakt: siehe Header) Heynitz: 035242/47212, D1: 0160/7141639 GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net === Schollglas Unternehmensgruppe ===
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.