[Benchmarking] Remarks about Postgis
cedric.briancon at geomatys.fr
Mon Aug 9 09:50:52 EDT 2010
about the postgis database I have to remarks to discuss:
1) Switch to lower case: some columns in the database are now in lower
case. In the shapefile like motorway.shp, you have the property
"TIPO_0601" which is exactly what I wrote in my SLD files. In the
postgis database you have the column "tipo_0601" so my styles will not
work for both shapefiles and postgis.
It is not really a big deal, I can duplicate my whole styles and change
the case, but I want others to be aware that they have to change the
case of their property name in their styles to use them on the postgis
database, if they want to use it.
2) When launching a postgis "envelope" request (select
envelope(the_geom) from contour_0), the response time is quite long
around 20s directly on the db server. It is understandable because there
are lots of data, but a WMS server in its GetCapabilities response is
supposed to display the envelope for each defined layer. That requieres
a significant amount of time to get the response (around 2minutes for me).
I see that there is already an index on the "the_geom" columns, which is
a good thing. Can something be done to improve this waiting time?
More information about the Benchmarking