[postgis-users] large postgres/postgis databases

[Christoph Spoerri]

Hi,
I have a test database with a table of 2.98 million rows (line features). It 
took 10 minutes to create a spatial index (GIST) and 2 minutes to analyze the 
data.

The box is a Dell server with 2 Xeon CPUs (2.4 GHz) and 2GB of RAM.

Cheers,
Christoph

On Monday 11 August 2003 04:08 pm, Chris Faulkner wrote:
> Hello
>
> I have just started to look at PostGIS as a means of managing my vector
> data.
>
> I am interested to know the volumes of data that people have created and
> indexed in their geometry fields. The manual mentions that a table of 1
> million rows has been indexed on a Solaris machine and that it took an
> hour. Are there any limits to the use of the GiST index ? Would it work on
> 10 million rows, for example ? If I had such a large table, what sort of
> spec machine would I need to build the index -- does the operation require
> a lot of memory ? Any examples of the use on larger databases would be very
> useful.
>
> Thanks all
>
> Chris
>
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users