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

[Sebastian E. Ovide]

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-ayland at 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 at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>



-- 
Sebastian E. Ovide
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20100721/d997cd6a/attachment.html>