[postgis-tickets] [PostGIS] #4216: Performance degradation in method `contains`

[PostGIS]

#4216: Performance degradation in method `contains`
-----------------------+---------------------------
  Reporter:  alvherre  |      Owner:  pramsey
      Type:  defect    |     Status:  new
  Priority:  medium    |  Milestone:  PostGIS 2.4.6
 Component:  postgis   |    Version:  2.4.x
Resolution:            |   Keywords:
-----------------------+---------------------------

Comment (by komzpa):

 Presence of BitmapIndexScan in PostGIS queries is also usually a sign of
 work_mem being set too low.

 Please also figure out what storage your table uses, main or extended. If
 it's extended it's not supposed to be affected by this change. If it's
 main, interesting who and why changed it from default :)

 Also @pramsey had a prototype of partial detoasting of compressed values.
 If it ever goes to postgres maybe it makes sense to revert the change? :)

 As a temporary solution, ND index still has the detoast-header code, so
 you can try to rebuild with ND opclass.

-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/4216#comment:3>
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.