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

PostgreSQL 17 support #6949

Closed devrimgunduz closed 1 month ago

devrimgunduz commented 4 months ago

What problem does the new feature solve?

Hi,

PostgreSQL 17 Beta1 is out, so this is the placeholder ticket for v17 support.

Regards, Devrim

What does the feature do?

Adds support for the upcoming PostgreSQL 17 release

Implementation challenges

No response

KES777 commented 3 months ago

I would try it. Is there any instructions how to build timescaledb with PG17? I saw that this is possible: https://github.com/timescale/timescaledb/pull/7105

svenklemm commented 1 month ago

It builds fine against PG17 but regression tests are failing so there is some work to be done to be fully compatible with PG17

devrimgunduz commented 2 weeks ago

GA is due soon. What is the plan for v17 supported release? Thanks!

fabriziomello commented 1 week ago

GA is due soon. What is the plan for v17 supported release? Thanks!

The plan is to release tsdb 2.17.0 with pg17 support next week.

The extension is huge and we use almost all extensible points in Postgres so any small change on upstream break our CI (few days ago we had some issues with pg17 on our main branch that now hopefully is ok). And for some CI workflows we need pg17 docker images.

To resume nowadays we essentially need the stable version be released to then we do our official release supporting new pg version. Let's see if we can improve it for next cycle.

morfair commented 2 days ago

We are really looking forward to the release of version 17. We need DB upgrade.