openmaptiles/layers/park
Patrik Sylve f70ae783b2
Set columns to null instead of dropping to avoid pg_deadlock during updates (#1710)
This PR addresses a pg_deadlock error that would cause an update to fail if a `select getmvt` was queried during update. The deadlock occurred due to an ALTER TABLE DROP COLUMN operation on temporary columns  ( `new_source_ids` and `old_source_ids`) in some linestring tables.

**Changes:**
*  instead of adding/dropping the columns during update, they are now updated and set to NULL. 
* Added new indexes on the source_ids columns  to speed up the UPDATE. 
* Will refresh `osm_park_polygon_dissolve_z4` concurrently in `park_polygon.refresh()` to avoid blocking. 

Co-authored-by: Patrik Sylve <patrik.sylve@t-kartor.com>
2025-02-28 13:27:52 +01:00
..
README.md Update diagrams 2017-12-04 12:06:28 +01:00
etl_diagram.png Fix park layer ETL diagram (#1278) 2021-10-25 08:12:17 -04:00
mapping.yaml Move aboriginal lands boundaries to boundary layer (#1604) 2024-01-21 10:37:02 +01:00
mapping_diagram.png Move aboriginal lands boundaries to boundary layer (#1604) 2024-01-21 10:37:02 +01:00
park.sql Move aboriginal lands boundaries to boundary layer (#1604) 2024-01-21 10:37:02 +01:00
park.yaml Move aboriginal lands boundaries to boundary layer (#1604) 2024-01-21 10:37:02 +01:00
style.json improve `class=path` styling (#1450) 2023-01-06 10:08:03 +01:00
update_park_polygon.sql Set columns to null instead of dropping to avoid pg_deadlock during updates (#1710) 2025-02-28 13:27:52 +01:00

README.md

park

Docs

Read the layer documentation at http://openmaptiles.org/schema#park

Mapping Diagram

Mapping diagram for park

ETL diagram

ETL diagram for park