[postgis-users] PostGIS server recommendations

[Paul Ramsey]

At $1500, haven't you already blown your budget on the processor and 
RAM?  Lots of RAM is good, keeps stuff in cache (remember to tune your 
instance to take advantage of it).

Second best is fast I/O.  Get a number (4?) of fast spinning disks 
(10000RPM+?) and put them into a RAID array (RAID5 or RAID10).  Use the 
Linux software RAID to save money on a RAID controller -- software RAID 
is plenty fast (faster than hardware RAID in a many cases).  The more 
disks you have, the more disk heads you have, and the faster you can 
pull data off the physical media.

P

galen at shackprices.com wrote:
> We're looking to buy a server in the next couple of weeks.  Our database
> will be 1 GB with over 10 - 40 tables.  We're primarily doing multi-field
> spatial and non-spatial queries (and sorts) on a 60 MB point table, but we
> are also doing a fair number of closest point calculations.
> 
> We expect (hope?) to have 10-20 concurrent users.
> 
> We're looking at AMD 64 Operons and 4 gigs of RAM, but we have a limited
> budget.  Any PostGIS-specific suggestions?  Any super-budget (under
> $1,500) recommendations?
> 
> Sincerely,
> Galen Ward
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users