[Benchmarking] PostGIS performance issues?

Paul Ramsey pramsey at opengeo.org
Sat Aug 28 23:41:59 EDT 2010

Weeeellll, I stripped the geometries down to 2d and added a little
memory to shared buffers. Try again and I'll keep my fingers

On Sat, Aug 28, 2010 at 5:07 PM, Paul Ramsey <pramsey at opengeo.org> wrote:
> 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.
> P
> 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