Re: [postgis-users] Index on the Geometry Column and GEOMETRYCOLLECTION EMPTY
Sorin Dudui wrote: Hello Mark, I am wondering if you had time to look in the issue. Thank you, Sorin Hi Sorin, Unfortunately I've was away working with a client last week. I did have a quick look at your example, but as yet haven't had a spare moment to sit and work through it in detail. ATB, 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
Re: [postgis-users] may have postgis store limits for a big project?
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
