[postgis-tickets] [PostGIS] #4822: Set costs and parallel settings on tiger functions

[PostGIS]

#4822: Set costs and parallel settings on tiger functions
-----------------------------+---------------------------
  Reporter:  robe            |      Owner:  robe
      Type:  defect          |     Status:  new
  Priority:  medium          |  Milestone:  PostGIS 3.1.1
 Component:  tiger geocoder  |    Version:  3.1.x
Resolution:                  |   Keywords:
-----------------------------+---------------------------
Description changed by robe:

Old description:

> Now that 9.6 is the minimum I can set costs and parallel settings.
>
> I discovered one of my geocodings was slower in PostgreSQL 12 because the
> geocoding process was repeating for each because the CTE is not always
> materialized now.  Setting costs high alleviates that.

New description:

 Now that 9.6 is the minimum I can set costs and parallel settings.

 I discovered one of my geocodings was slower in PostgreSQL 12 because the
 geocoding process was repeating for each because the CTE is not always
 materialized now.  Setting costs high setting expected rows returned from
 default 1000 to 1 alleviates that.

 In fact the ROWS count seemed to have a much greater impact than anything
 else.

--

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