[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