Changes between Initial Version and Version 2 of Ticket #4822


Ignore:
Timestamp:
Jan 5, 2021, 4:34:09 AM (4 years ago)
Author:
robe
Comment:

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #4822

    • Property Version 3.0.x → 3.1.x

  • Ticket #4822 – Description

    initial v2  
    11Now that 9.6 is the minimum I can set costs and parallel settings.
    22
    3 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.
     3I 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.
     4
     5In fact the ROWS count seemed to have a much greater impact than anything else.