[Benchmarking] PostGIS performance issues?

[Michael Smith]

Andrea,

Did you make any runs against Oracle to see if its the database server vs
postgis being disk bound?

I'll go ahead and do some runs with Oracle to see what I'm getting.

Mike


On 8/28/10 6:02 AM, "Andrea Aime" <aaime at opengeo.org> wrote:

> Hi,
> to explore a hunch this morning I made a few full runs of the
> benchmarks against postgis from GeoServer and MapServer fcgi
> getting more or less the same bad results: either of them hardly
> goes beyond the 6 requests per second.
> 
> Looking at the database machine the test is disk bound with
> postgres reading less than 10MB/s for all the test duration
> (as reported by vmstat 1)
> 
> I'm wondering if there might be anything wrong with the
> postgres/postgis configuration itself?
> 
> The shapefile tests on the linux server are not disk bound
> for mapserver and the performance is completely different
> (they are disk bound for GS but I'm working on it ;-) )
> 
> Cheers
> Andrea