[postgis-users] PostGIS on an old NAS drive or a new rendering machine

[James Stott]

I am being offered a choice at work to move my PostGIS to a new server.
I am being offered two choices. I do not do particularly large queries
on QGIS, and the database are mainly used within the business. Some of
my tables are quite large (9,000,000 rows of polygon data) but there
isn't too much in the way of complex joins or complex spatial queries.
The machine will also have apache and probably GeoServer as well.

1) Use an old NAS drive (about 4 or 5 years old). 

Windows Storage Server 2003 R2
Intel Xeon CPU 5150 at 2.66GHz
1GB RAM
1TB HD

This machine would only be used for PostGIS and storing Raster files for
access on the file server.

2) Run PostGIS on a brand new rendering machine

Intel 3960x Extreme edition 6 core processor
LGA2011 motherboard
16gb Quad Channel ram
ATI FirePro V5900 2Gb
1.5TB 6Gb/s HD
DVD/CD
Windows 7 64bit

This machine will be also used to render 3D Max work, so I would be
sharing this machine with others.

Can anyone comment on which of these would be better for me to use? I am
concerned that whilst rendering is taking place on the render machine it
will slow PostGIS down a lot. Is this the case?

Regards,

James

James Stott BSc (Hons) MSc | Senior Professional
Nicholas Pearson Associates | 30 Brock Street | Bath | BA1 2LN
T: 01225 445548 | M: -
http://www.npaconsult.co.uk/ 


http://www.npaconsult.co.uk/http://www.npaconsult.co.uk/about-news.asp
http://www.npaconsult.co.uk/terms.asp
This Electronic Transmission is intended only for the attention of the addressee. It may contain privileged and confidential information. If you are not the person for whom it is intended, you must not copy, distribute or take any action in reliance on it. If you have received this electronic transmission in error please notify us immediately by telephone, delete the transmission and destroy any hard copies.
Nicholas Pearson Associates has used all reasonable efforts to ensure that this message and any attachments are free from viruses.
Nicholas Pearson Associates, 30 Brock Street, Bath, BA1 2LN , Tel: +44 (0) 01225 445548, Fax: +44 (0) 01225 312387, Website: http://www.npaconsult.co.uk/