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

Mark Cave-Ayland mark.cave-ayland at siriusit.co.uk
Tue Jul 20 04:04:56 PDT 2010

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:


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 :)



Mark Cave-Ayland - Senior Technical Architect
PostgreSQL - PostGIS
Sirius Corporation plc - control through freedom
t: +44 870 608 0063

Sirius Labs: http://www.siriusit.co.uk/labs

More information about the postgis-users mailing list