[Geoserver-devel] [jira] (GEOS-5526) WFS "update" on partitioned postgres table will generate SELECT without using partition attribute

GeoServer GeoServer Developer
,
1

Marco Corsi created ImprovementGEOS-5526
WFS “update” on partitioned postgres table will generate SELECT without using partition attribute

Issue Type:

ImprovementImprovement

Affects Versions:

2.2.3, 2.1.4

Assignee:

Andrea Aime

Components:

WFS

Created:

03/Jan/13 4:47 AM

Description:

The problem is related to partitioned tables (using PostgreSQL / PostGIS database but probably it is still the same with other DBs).

When I use the WFS protocol (transaction / update) on the parent table it successfully update using partition attribute but, after, it goes in a “Post process update for boundary update and featureValidation” and this part of the code is not using partition attribute causing a full tablescan. Basically, if the table is really big (which is normally the case for using partitioned tables) this is causing the WFS to be not usable (too slow).

Environment:

Redhat 6

Project:

GeoServer

Priority:

MajorMajor

Reporter:

Marco Corsi
This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your [JIRA administrators](https://jira.codehaus.org/secure/ContactAdministrators!default.jspa). For more information on JIRA, see: [http://www.atlassian.com/software/jira](http://www.atlassian.com/software/jira)