PostgreSQL 17

[ur5us]

Required Terms

• I agree to follow this project's Code of Conduct
• I have read and accept the Salesforce Program Agreement

What service(s) is this request for?

Postgres

Tell us about what you're trying to solve. What challenges are you facing?

Improve performance for (Rails) apps by leveraging “performance of queries with IN clauses that use B-tree indexes”, faster VACUUM, s. https://www.postgresql.org/about/news/postgresql-17-released-2936/

[jbrown-heroku]

Thank you for this suggestion @ur5us, and indeed sounds like great benefits of PG17! We are on track to deliver PG17 in Q1 2025. Stay tuned.

[jeffbax]

Would love to see this one land earlier than the typical EOQ1/Q2, there seem to be such notable improvements to queries (namely, the IN() clause) that are extremely common to Rails apps.

[jbrown-heroku]

Thank you for your input @jeffbax !
We will see what we can to expedite the release of the first point version in Q1.

[ryantownsend]

Is there any update on the timeline for PG17? Were you able to expedite to Q1 @jbrown-heroku?

[anandtripathi5]

Hi, is there any update on the timeline for PG17, looking forward for using it.

[jbrown-heroku]

Thank you for your patience! Update: We are on track for delivery targeting March-April.
There are many new features and improvements with PG17 to look forward to, including the inclusion of uuid7!