Hi.
I hope this PPT will usable to you.
http://www.slideshare.net/jangbi882/foss4-g-portland-2014-jhkwunver2
It is case of rendering big size vector date by GeoServer with PostGIS.
I think page 25 will help you. There is a SQL for find slow query.
Regards,
BJ Jang
2014-10-16 18:25 GMT+09:00 An
On Thu, Oct 16, 2014 at 10:26 AM, Alvey,David (Chief Executives) <
david.al...@derbyshire.gov.uk> wrote:
> I am experiencing significant delays in rendering png8 tiles from
> geoserver when the data is stored in in SQL server opposed to a shapefile.
>
> There are almost 2 million polygon objects
AM
> *To:* 'Alvey,David (Chief Executives)'; '
> geoserver-users@lists.sourceforge.net'
> *Subject:* Re: [Geoserver-users] Geoserver and SQL performance
>
>
>
> Hi,
>
>
>
> Two alternatives:
>
> 1. Spatial index does not exist or is broke
geoserver-users@lists.sourceforge.net'
Subject: Re: [Geoserver-users] Geoserver and SQL performance
Hi,
Two alternatives:
1. Spatial index does not exist or is broken.
2.Geoserver can’t utilize spatial index even it exists –> bug.
I would study first alternative 1).
-Jukka Rahkonen-
Lähett
etty: 16. lokakuuta 2014 11:26
Vastaanottaja: geoserver-users@lists.sourceforge.net
Aihe: [Geoserver-users] Geoserver and SQL performance
I am experiencing significant delays in rendering png8 tiles from geoserver
when the data is stored in in SQL server opposed to a shapefile.
There are almost 2
I am experiencing significant delays in rendering png8 tiles from geoserver
when the data is stored in in SQL server opposed to a shapefile.
There are almost 2 million polygon objects (Ordnance Survey Vector Map Local
Buildings region).
The SLD is configured only to render the buildings when zoo