Sebastian E. Ovide wrote:
Hi Mark,
what hardware would you use to manage tables of 40M rows ? (simple
queries without Joins !) Each query must response in under 0.1 sec.
thanks
Hi Sebastian,
In terms of CPU power, any modern multi-core processor will perform
absolutely fine. Make sure that you have plenty of RAM for caching (more
than 4Gb) with nice fast disks to boot.
As long as the majority of your queries don't return more than a few
hundred rows then I think you will be fine.
HTH,
Mark.
--
Mark Cave-Ayland - Senior Technical Architect
PostgreSQL - PostGIS
Sirius Corporation plc - control through freedom
http://www.siriusit.co.uk
t: +44 870 608 0063
Sirius Labs: http://www.siriusit.co.uk/labs
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
