web.update_invalid_addresses slow?

[britiger]

It seams running web.update_invalid_addresses it is very slow using PostgreSQL 12.

[britiger]

Checked with different conditions (all dach):
pgsql 12 / postgis 3 (frech imported):

explain analyze select web.update_invalid_addresses(-1829065,true);
                                         QUERY PLAN                                         
--------------------------------------------------------------------------------------------
 Result  (cost=0.00..0.26 rows=1 width=1) (actual time=19349.319..19349.320 rows=1 loops=1)
 Planning Time: 0.100 ms
 Execution Time: 19353.671 ms

pgsql 12 / postgis 3 (Running since 11-2019 with daily updates):

explain analyze select web.update_invalid_addresses(-1829065,true);
                                         QUERY PLAN                                         
--------------------------------------------------------------------------------------------
 Result  (cost=0.00..0.26 rows=1 width=1) (actual time=27849.066..27849.067 rows=1 loops=1)
 Planning Time: 0.087 ms
 Execution Time: 27852.308 ms

pgsql 11 / postgis 2.5 (Running until 11-2019)

explain analyze select web.update_invalid_addresses(-1829065,true);
                                        QUERY PLAN                                        
------------------------------------------------------------------------------------------
 Result  (cost=0.00..0.26 rows=1 width=1) (actual time=5740.886..5740.887 rows=1 loops=1)
 Planning Time: 0.044 ms
 Execution Time: 5740.915 ms