[postgis-users] Completely Non-Scientific Performance Test (CNSPT)

[Nedjo Rogers]

Paul,

Is there a PostGIS database on a Refractions server that is publicly
accessible (for test queries)?  If so, (a) what are the connection
parameters, and (b) are metadata available for the feature layers?

Thanks.
----- Original Message -----
From: Paul Ramsey <pramsey at refractions.net>
To: <postgis-users at postgis.refractions.net>
Sent: Tuesday, May 07, 2002 11:29 AM
Subject: [postgis-users] Completely Non-Scientific Performance Test (CNSPT)


> <CNSPT>
> In the interests of being "kewl" we loaded an 8 million record table
> into PostGIS on our new database server (Dual Athlon 1.6Ghz, 2Gb RAM).
> Index building took about 40 minutes. Vacuuming took another 20 or so.
> Retrieving a 4 feature subset via spatial query took less time than we
> could measure. Essentially instant. Things only got slow when retrieving
> subsets in the thousands of features.
> </CNSPT>
>
> --
>       __
>      /
>      | Paul Ramsey
>      | Refractions Research
>      | Email: pramsey at refractions.net
>      | Phone: (250) 885-0632
>      \_
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>