[postgis-users] Throughput/performance for postGIS

[Paul Ramsey]

I will be interested in hearing what others say, but my guess would be 
that GX would be the most heavily scaled PostGIS implementation in the 
world.

Gregory S. Williamson wrote:

> I've been charged with investigating postGIS as a replacement for our
> current Informix runtime (9.3), which uses the Spatial blade.
> Currently we use two Sun Sparc/Ultra 80 boxes with 3 CPUS dedicated
> to Informix.
> 
> Originally this company tried Oracle, but, as the Firesign Theater
> put it, "He's no fun, he fell right over!" ... Informix works well
> but charges a hefty amount for each CPU. We're running more than a
> million hits a day, not evenly spread, natch.
> 
> We use our database to calculate the image files we have within a
> given area (ST_Union, Intersect and the like).
> 
> Are there documents on performance of postGres on various platforms
> that I might be able to get some ideas from ? Such issues as multiple
> CPU vs single CPU, Operating System (we're leaning towards Linux of
> some flavor) would be of interest.

We have found Solaris to be slower than Linux general, and others have 
found Windows slower than Linux, but that is the extent of OS experience 
I haev heard. I would be interested to know if FreeBSD has any 
performance advantages over Linux for PostGIS apps.

> Any suggestions from users that have/are really beating up postGIS
> would be welcome !
> 
> Thanks,
> 
> Greg Williamson DBA GlobeXplorer LLC
> 
> _______________________________________________ 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
      \_