[Geoserver-devel] [jira] (GEOS-6691) Geoserver causes a query SELECT NULL AS TABLE_CAT... to be generated by JDBC over and over again

Jakob Ventin created an issue

GeoServer / BugGEOS-6691

Geoserver causes a query SELECT NULL AS TABLE_CAT… to be generated by JDBC over and over again

Issue Type:

BugBug

Affects Versions:

2.6-RC1

Assignee:

Andrea Aime

Created:

26/Sep/14 4:04 AM

Environment:

PostgreSQL 9.3.0 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.4.7 20120313 (Red Hat 4.4.7-3), 64-bit, POSTGIS=“2.1.0 r11822” GEOS=“3.4.2-CAPI-1.8.2 r3921” PROJ=“Rel. 4.8.0, 6 March 2012” LIBXML=“2.7.6” LIBJSON=“UNKNOWN” (core procs from “2.1.1 r12113” need upgrade)

Priority:

MajorMajor

Reporter:

Jakob Ventin

As described in http://osgeo-org.1560.x6.nabble.com/Geoserver-2-6-RC1-slow-WMS-td5161306.html, Geoserver versions 2.6rc1 -> causes a SELECT NULL AS TABLE_CAT, … to be executed over and over again in PostGIS, slowing down the query significantly.

Add Comment

Add Comment

This message was sent by Atlassian JIRA (v6.1.6#6162-sha1:7af547c)

Atlassian logo