PostgreSQL 17 is now available on Scalingo: faster and just as easy to upgrade

PostgreSQL 17 joins Scalingo’s Database-as-a-Service offering. This new version brings performance improvements and enhances the way applications work with their data, especially when handling JSON.

Whether you deploy critical applications or testing environments, you benefit from a sovereign managed service that supports you throughout the entire lifecycle of your database — from initial deployment to upgrades, backups, and support from our engineers based in France and across Europe.

Why PostgreSQL 17 on Scalingo?

PostgreSQL 17 introduces several improvements that make the database faster, easier to operate, and better suited to modern applications.

• Faster maintenance operations: PostgreSQL 17 improves VACUUM, a mechanism essential to database maintenance. In practice, this results in smoother restore or upgrade operations and a quicker return to normal performance.
• Query JSON data more easily with JSON_TABLE: PostgreSQL 17 introduces the JSON_TABLE function, which transforms a JSON document into a relational table. This makes it easier to query and manipulate semi-structured data using standard SQL queries.
• Improved performance: Sequential reads and write throughput under heavy load have been improved. Your database remains more responsive and delivers more stable performance when heavily used.

A simple and reliable upgrade process

Upgrading to PostgreSQL 17 on Scalingo remains just as straightforward as with previous versions.

The upgrade process has been designed to limit service interruption to just a few minutes, whether you are on a Starter, Business, or Enterprise plan.

1. Check the prerequisites. Make sure your instance is running the latest PostgreSQL 16 minor version. If not, we will suggest the required intermediate upgrades. This step ensures optimal compatibility for both your database and its extensions.
2. Launch the upgrade in one click. From your database dashboard, simply click the “Major Upgrade” button. We take care of the rest, with no manual intervention required on your side.
3. Quickly available, then gradually optimized. Once the upgrade is complete, your database becomes accessible again within a few minutes. Some internal operations, such as ANALYZE, may continue running in the background and can temporarily impact performance before the system fully stabilizes.

To help you understand and prepare for this upgrade, we have created a dedicated section in our documentation explaining the major upgrade process in detail. Learn more here: Understanding the major upgrade process.

Your extensions, up to date

Beyond the core engine, the extensions supported on Scalingo expand the range of use cases covered by PostgreSQL. From time-series workloads to vector search, geospatial data, and anonymization, the main extensions are available in recent versions:

• TimescaleDB: 2.25.2
• PostGIS: 3.6.2
• pgvector: 0.8.2
• PostgreSQL Anonymizer: 3.0 (including important security fixes)

You can find the full list of supported extensions and their respective versions in our documentation.

Upgrade to PostgreSQL 17 today

PostgreSQL 17 is now available on Scalingo in a mature and stable version that delivers tangible improvements in performance and reliability. Migrating takes only a few minutes thanks to the one-click upgrade available in your dashboard. We encourage you to plan your upgrade today. And if you have any questions, our support team is ready to help you every step of the way.

Curious about Scalingo or want to try PostgreSQL 17 on a managed platform that simplifies application deployment? Try Scalingo today and take advantage of our free trial offer!