Related to this: https://github.com/MO-RISE/pontos-hub/blob/main/database/always-initdb.d/010-pontos-api-setup.sql#L5 (Which should be changed to ... DISTINCT ON (vessel_id) vessel_id ...)
But the main problem is this: timescale/timescaledb#3070
Where the current skip-scan functionality in TimescaleDB does not work together with compressed chunks.
Related to this: https://github.com/MO-RISE/pontos-hub/blob/main/database/always-initdb.d/010-pontos-api-setup.sql#L5 (Which should be changed to
... DISTINCT ON (vessel_id) vessel_id ...)But the main problem is this: timescale/timescaledb#3070
Where the current skip-scan functionality in TimescaleDB does not work together with compressed chunks.