Hardware suggestions

From: christian(dot)braun(at)tudor(dot)lu
To: pgsql-performance(at)postgresql(dot)org
Subject: Hardware suggestions
Date: 2007-06-19 10:28:30
Message-ID: OF414BF8DA.327C4584-ONC12572FF.00398A72-C12572FF.00398A77@tudor.lu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

<FONT face="Default Sans Serif,Verdana,Arial,Helvetica,sans-serif" size=2><div>Hi list members,<br><br>I have a question regarding hardware issues for a SDI (Spatial data infrastructure). It will consist of PostgreSQL with PostGIS and a UMN Mapserver/pmapper set up.<br>At our institute we are currently establishing a small GIS working group. The data storage for vector data should be the central PostGIS system. Raster data will be held in file system.<br>Mostly the users are accessing the data base in read only mode. From the client side there is not much write access this only will be done by the admin of the system to load new datasets. A prototype is currently running on an old desktop pc with ubuntu dapper - not very powerfull, of course!<br>We have about 10000 &#8364; 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. Since I 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 want to stay at Ubuntu because of the software support, espacially for the GIS-Systems. I think we need at least about 300-500Gb for storage and the server you get for this price are about two dualcore 2.0 - 2.8 GHz Opterons.<br>Do you have any suggestions for the hardware of a spatial data base in that pricing category?<br><br>Thanks in advance and greetings from Luxembourg,<br>Christian<br></div></FONT>

Attachment Content-Type Size
unknown_filename text/html 1.5 KB

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Karl Wright 2007-06-19 11:04:17 Re: Performance query about large tables, lots of concurrent access
Previous Message Andrew Kelly 2007-06-19 08:23:27 Re: [GENERAL] [PERFORM] Postgres VS Oracle