<font face="Default Sans Serif,Verdana,Arial,Helvetica,sans-serif" size="2"><div>Hi list members,<br /><br />I have a
questionregarding hardware issues for a SDI (Spatial data infrastructure). It will consist of PostgreSQL with PostGIS
anda UMN Mapserver/pmapper set up.<br />At our institute we are currently establishing a small GIS working group. The
datastorage for vector data should be the central PostGIS system. Raster data will be held in file system.<br />Mostly
theusers are accessing the data base in read only mode. From the client side there is not much write access this only
willbe done by the admin of the system to load new datasets. A prototype is currently running on an old desktop pc with
ubuntudapper - not very powerfull, of course!<br />We have about 10000 € to spend for a new server including the
storage.Do you have any recommendations for us?<br />I have read a lot of introductions to tune up PostgreSQL systems.
SinceI don't have the possibility to tune up the soft parameters like cache, mem sizes etc., I wondered about the
hardware.Most things were about the I/O of harddisks, RAM and file system. Is the filesystem that relevant? Because wo
wantto stay at Ubuntu because of the software support, espacially for the GIS-Systems. I think we need at least about
300-500Gbfor storage and the server you get for this price are about two dualcore 2.0 - 2.8 GHz Opterons.<br />Do you
haveany suggestions for the hardware of a spatial data base in that pricing category?<br /><br />Thanks in advance and
greetingsfrom Luxembourg,<br />Christian<br /></div></font>