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@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/ _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users