[Benchmarking] PostGIS performance issues?

Paul Ramsey pramsey at opengeo.org
Sat Aug 28 20:07:52 EDT 2010

This is unfortunately, I'm packing today and gone for the next week.
I'm running a bunch of updates now to strip the M and Z from the data,
but not sure that's going to do much. Trying to figure out if we have
any installation differences compared to Oracle.


On Sat, Aug 28, 2010 at 3:07 PM, Andrea Aime <aaime at opengeo.org> wrote:
> Paul Ramsey ha scritto:
>> Someone shut it off perhaps? Were Oracle and PgSQL thrashing memory?
>> If we both tried to take a big enough shared memory segment  nasty
>> things could happen.
> With Michael we did some tests and confirmed PostGIS to always
> be disk bound for both GeoServer and MapServer runs, even with Oracle
> shut down
> However when Michael reversed the roles Oracle did well and was not
> disk bound at the second (or third?) run. I guess POstgres is still
> down since then.
> Mind, Oracle has the data in 2D, so maybe that's the cause.
> Or maybe it's something different, don't really know :-)
> Cheers
> Andrea
> --
> Andrea Aime
> OpenGeo - http://opengeo.org
> Expert service straight from the developers.
> _______________________________________________
> Benchmarking mailing list
> Benchmarking at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/benchmarking

More information about the Benchmarking mailing list