Re: [postgis-users] Index on the Geometry Column and GEOMETRYCOLLECTION EMPTY

2010-07-26 Thread Mark Cave-Ayland
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

Re: [postgis-users] may have postgis store limits for a big project?

2010-07-26 Thread Mark Cave-Ayland
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 th