[postgis-users] Completely Non-Scientific Performance Test (CNSPT)
Paul Ramsey
pramsey at refractions.net
Tue May 7 13:04:55 PDT 2002
Afraid not. Opening up a db to anonymous access would not be something I
would like to do on anything but a machine I care not at all about...
(and I do not have any of those at the moment)
Paul
Nedjo Rogers wrote:
>
> 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
> >
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
--
__
/
| Paul Ramsey
| Refractions Research
| Email: pramsey at refractions.net
| Phone: (250) 885-0632
\_
More information about the postgis-users
mailing list