Heroku Postgres PGX: Bigger Databases, Improved Infrastructure, Same Price

Today, we’re excited to announce a major update to Heroku Postgres with a new lineup of production plans. These plans are the first component of Heroku Postgres PGX, the next generation of our managed Postgres solution.

PGX Plans introduce larger database sizes, more generous resource allocations, and a broader set of options to suit your needs and to help your applications scale more smoothly. PGX Plans are generally available as of today, and all new Postgres databases will be created on our latest generation of Postgres infrastructure. Underneath the hood, we've upgraded the CPU, memory, storage, and networking aspects to ensure your Postgres database is running smoothly at scale.

To take a look at which of your Heroku Postgres databases can take advantage of PGX Plans now and how, go to data.heroku.com.

New Production Plans for More Flexible Scaling

Our new lineup of 8 plan levels offers gradual

New Plans, More Possibilities dialog window

Continue reading “Heroku Postgres PGX: Bigger Databases, Improved Infrastructure, Same Price”

PostgreSQL 10 Generally Available on Heroku

Today, we're happy to announce full support for PostgreSQL 10, opening our managed Postgres solution to the full slate of features released after a successful two-month Beta period. PostgreSQL 10 is now the default version for all new provisioned Heroku Postgres databases. All Postgres extensions, tooling, and integration with the Heroku developer experience are ready to use, giving you the power of PostgreSQL 10 with the ease and usability of Heroku for building data-centric applications.

We'd like to re-emphasize a few features – among the many released in Postgres 10 – that we are particularly excited about.

Native Table Partitioning

A pattern we often see in databases in our fleet is one or two tables growing at a rate that’s much larger and faster than the rest of the tables in the database. Query times within the application will start to rise, bulk loads will take longer, and creating indexes

Continue reading “PostgreSQL 10 Generally Available on Heroku”

PostgreSQL 10 Now Available in Beta on Heroku Postgres

Earlier this month, PostgreSQL 10.0 was released. Today, we are excited to announce PostgreSQL 10 is available in beta on Heroku, bringing a number of notable feature and performance improvements to our managed PostgreSQL database service.

The beta provides customers who want to try out the new release an easy way to do so, while customers who are happy with the current version can continue to stay on version 9.6 until we make version 10 generally available. Also, new databases will continue to default to version 9.6 until we release version 10 to GA.

While PostgreSQL 10 has many feature and performance benefits, we’d like to highlight several that we are most looking forward to:

Performance Improvements

Most Heroku Postgres users will notice a performance boost when using PostgreSQL 10 for certain types of queries. The introduction of improved parallel queries, which optimize common types

Continue reading “PostgreSQL 10 Now Available in Beta on Heroku Postgres”