Thread: System requirements
Hi, I've been checking the archives and documentation for what the system requirements are for a PostgreSQL database.... It's to be used for a database with 8 users, and has MS-Access front-end which causes app. 2 connections per user. My idea was: 128Meg Ram 20 Gig HD 500 Mhz. Celeron will this be sufficient, or will it have be something else? Also what is required more, memory or CPU-power? hoping for an answer, Joost Roeleveld
This depends entirely(?) on what kinds of tables you use, especially their size, and what kind of queries you want to do with it. 128MB RAM should be fine for average applications, the hard disk size pretty much just limits how much data you can store (and sort), and the processor factor is hard to gauge. Having two processors might help more than anything else. But in general it's for you to find out. On 2000-01-24, J. Roeleveld mentioned: > Hi, > > I've been checking the archives and documentation for what the > system requirements are for a PostgreSQL database.... > > It's to be used for a database with 8 users, and has MS-Access front-end > which causes app. 2 connections per user. > > My idea was: > > 128Meg Ram > 20 Gig HD > 500 Mhz. Celeron > > will this be sufficient, or will it have be something else? > > Also what is required more, memory or CPU-power? > > hoping for an answer, > > Joost Roeleveld > > > ************ > > -- Peter Eisentraut Sernanders väg 10:115 peter_e@gmx.net 75262 Uppsala http://yi.org/peter-e/ Sweden
The disks you use also play a big part in the performance you get. If you are going to have multiple simultaneous connections accessed the server, I'd go with a good SCSI disk array. Maybe even RAID if it's going to be under a high load. At 07:49 PM 1/24/00, Peter Eisentraut wrote: >This depends entirely(?) on what kinds of tables you use, especially their >size, and what kind of queries you want to do with it. 128MB RAM should be >fine for average applications, the hard disk size pretty much just limits >how much data you can store (and sort), and the processor factor is hard >to gauge. Having two processors might help more than anything else. But in >general it's for you to find out. > > >On 2000-01-24, J. Roeleveld mentioned: > > > Hi, > > > > I've been checking the archives and documentation for what the > > system requirements are for a PostgreSQL database.... > > > > It's to be used for a database with 8 users, and has MS-Access front-end > > which causes app. 2 connections per user. > > > > My idea was: > > > > 128Meg Ram > > 20 Gig HD > > 500 Mhz. Celeron > > > > will this be sufficient, or will it have be something else? > > > > Also what is required more, memory or CPU-power? > > > > hoping for an answer, > > > > Joost Roeleveld > > > > > > ************ > > > > > >-- >Peter Eisentraut Sernanders väg 10:115 >peter_e@gmx.net 75262 Uppsala >http://yi.org/peter-e/ Sweden > > > >************