PostgreSQL 12 is now available on Clever Cloud.

It comes with optimizations to space utilization and read/write performance for B-tree indexes and partitioning performance enhancements, including improved query performance on tables with thousands of partitions, improved insertion performance with INSERT and COPY, and the ability to execute ALTER TABLE ATTACH PARTITION without blocking queries. Here is the changelog.

You can either create a new addon with version 12 or migrate your addons to version 12 via the one-click migration tool available in the addon context menu. For now, only dedicated databases can be provisonned in version 12. The free plan will be available in the coming weeks.

PostgreSQL 12 does not support timetravel extension anymore, we we automatically remove it during one-click migration it will fail if the extension is used; which means you will have to adapt your database to be compatible with PostgreSQL 12.

Now, PostgreSQL versions 9.6, 10, 11 and 12 are available on Clever Cloud.

This new release comes with two Clever Cloud PostgreSQL features:

  • Extensions activation using your PostgreSQL addon dashboard on free plans is available (BETA);
  • Premium clients can ask support to activate disk encryption for free (a 10% fee will be applied for regular customers). This feature requires a migration.

Profile picture of Alexandre Duval
By Alexandre Duval

IT Engineer working on data streams and processing using distributed systems on logs and addons systems.