[postgis-users] PostGIS server recommendations
pramsey at refractions.net
Wed Jul 5 14:30:12 PDT 2006
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.
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?
> Galen Ward
> postgis-users mailing list
> postgis-users at postgis.refractions.net
More information about the postgis-users