[postgis-tickets] [PostGIS] #4163: ST_AsMVT: Resource leak under parallel plans

PostGIS trac at osgeo.org
Tue Aug 28 08:49:15 PDT 2018


#4163: ST_AsMVT: Resource leak under parallel plans
------------------------+---------------------------
 Reporter:  Algunenano  |      Owner:  Algunenano
     Type:  defect      |     Status:  assigned
 Priority:  high        |  Milestone:  PostGIS 2.5.0
Component:  postgis     |    Version:  2.4.x
 Keywords:              |
------------------------+---------------------------
 Currently the resources generated during the aggregation process for
 St_AsMVT are freed in `encode_values`. The problem is that, in parallel
 plans, only one of the workers calls this function but all of them
 generate these intermediate resources.

 This can be an issue as we cache not only memory (which should be freed at
 the end of the query) but Tuple Descriptors too, so Postgresql has to
 cleanup after as and throws warnings:
 {{{
  2018-08-28 15:20:05.675 UTC [8063] WARNING: TupleDesc reference leak:
 TupleDesc 0x7fef02669288 (2249,0) still referenced
  2018-08-28 15:20:05.675 UTC [8063] WARNING: TupleDesc reference leak:
 TupleDesc 0x7fef02669288 (2249,0) still referenced
 }}}

 Affects 2.5 and trunk.

-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/4163>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.


More information about the postgis-tickets mailing list