Opened 2 months ago
Last modified 5 weeks ago
#4822 new defect
Set costs and parallel settings on tiger functions
Reported by: | robe | Owned by: | robe |
---|---|---|---|
Priority: | medium | Milestone: | PostGIS 3.1.2 |
Component: | tiger geocoder | Version: | 3.1.x |
Keywords: | Cc: |
Description (last modified by )
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.
Change History (4)
comment:1 Changed 2 months ago by
Version: | 3.0.x → 3.1.x |
---|
comment:2 Changed 2 months ago by
Description: | modified (diff) |
---|
comment:3 Changed 2 months ago by
comment:4 Changed 5 weeks ago by
Milestone: | PostGIS 3.1.1 → PostGIS 3.1.2 |
---|
Note: See
TracTickets for help on using
tickets.
In a3c1c63/git: