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 On Tue, Jul 20, 2010 at 12:04 PM, Mark Cave-Ayland < mark.cave-ayl...@siriusit.co.uk> wrote: > salas wrote: > > Hello to all: >> I am working in a project where they are managed more than 20 geoespatials >> thematics. Each thematic one has a considerable volume of since information >> it is of the whole country (I am speaking of a lot more than a million of >> records). In the project we need to make (mostly) intersection consultations >> keeping in mind literal attributes. >> I need to know the experience of somebody in a project of this span and if >> PostGIS would present some limitation therewith. >> regards yuriesky >> > > Since PostGIS makes use of the underlying PostgreSQL database, then you may > find the following table useful: > > > http://wiki.postgresql.org/wiki/FAQ#What_is_the_maximum_size_for_a_row.2C_a_table.2C_and_a_database.3F > > For several projects I've been involved in, we've had databases into the > 10s of millions of rows and PostgreSQL/PostGIS has handled it fine without > breaking a sweat :) > > > 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 > -- Sebastian E. Ovide
_______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users