timescale / timescaledb

An open-source time-series SQL database optimized for fast ingest and complex queries. Packaged as a PostgreSQL extension.
https://www.timescale.com/
Other
17.61k stars 883 forks source link

Backport to 2.15.x: #6908: Fix gapfill behaviour around dst switches #6914

Closed timescale-automation closed 4 months ago

timescale-automation commented 4 months ago

This is an automated backport of #6908: Fix gapfill behaviour around dst switches. The original issue is #6788. This PR will be merged automatically after all the relevant CI checks pass. If this fix should not be backported, or will be backported manually, just close this PR. You can use the backport branch to add your changes, it won't be modified automatically anymore.

For more details, please see the documentation

Original description

Fix gapfill behaviour around dst switches

When advancing local time we might not actually advance the timestamp we process e.g. when we switch to DST in spring the local time advances by 1 hour but the UTC time stays the same. Therefore we need to keep advancing until we actually move forward.

Fixes: #6788