[Benchmarking] PostGIS performance issues?

[Paul Ramsey]

I'm actually not finding a postgis running on the db machine... I
wonder what's up?

On Sat, Aug 28, 2010 at 3:07 AM, Michael Smith
<michael.smith at usace.army.mil> wrote:
> 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
>
> _______________________________________________
> Benchmarking mailing list
> Benchmarking at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/benchmarking
>