#postgres

Sudarshan Hiray 5 Nov 2025 7 min read

Modern businesses don’t just run on Salesforce—they run on entire ecosystems of applications. At Heroku, we operate dozens of services alongside our Salesforce instance such as billing systems, user management platforms, analytics engines, and support tools. Traditional approaches to unifying this data create more problems than they solve. In this article, we’ll see how we […] The post Building an…

engineeringdatapostgres

Kavya Premkumar 29 May 2025 7 min read

If you’ve ever deployed an app on Heroku, chances are you’ve used Heroku Postgres — our fully managed, reliable, and scalable Postgres database service. It’s the backbone for millions of applications, from weekend side projects to enterprise-grade systems running in production. But Postgres, like all software, continues to evolve. With new versions released each year, […] The post Heroku Postgres…

engineeringcliheroku postgresplatform updatespostgres

Ken W. Alger 19 Nov 2024 9 min read

Your organization may have many reasons to move a cloud service from one provider to another. Maybe you’ve found a better performance-versus-cost balance elsewhere. Maybe you’re trying to avoid vendor lock-in. Whatever your reasons, the convenience and general interoperability of cloud services today put you in the driver’s seat. You get to piece together the […] The post Planning Your…

uncategorizeddatabasedeveloper toolspostgressql

Jonathan Brown 21 May 2024 5 min read

We’re thrilled to launch our new Heroku Postgres Essential database plans. These plans have pgvector support, no row count limits, and come with a 32 GB option. We deliver exceptional transactional query performance with Amazon Aurora as the backing infrastructure. One of our beta customers said: “The difference was noticeable right from the start. Heroku […] The post Introducing New…

newsdatabasedeveloper toolsheroku postgrespostgres

Greg Nokes 21 Jan 2021 1 min read

We are excited to announce that we are moving Connection Pooling for Heroku Postgres into GA. Connection Pooling unlocks the ability to use up to 10,000 client connections to a Heroku Postgres Database, without adversely impacting performance on the database. This will unlock more complex and higher scale applications with simpler architectures on the Heroku […] The post Connection Pooling…

newscloud infrastructuredatabasepostgres

Scott Truitt 11 Jun 2020 4 min read

We are thrilled to announce that Heroku Shield for Redis is now generally available and certified for handling PHI, PII, and HIPAA-compliant data. Heroku Shield for Redis is the final missing data service for Heroku Shield, which is an integrated set of Heroku services with additional security features needed for building high compliance applications. All […] The post Heroku Shield…

newsapache kafkadataheroku shieldpostgres

Scott Truitt 4 Feb 2020 2 min read

After a successful evaluation period, PostgreSQL 12 is now the default version for new Heroku Postgres databases and an available upgrade for existing databases. I want to emphasize a few key changes and improvements in Postgres 12: Native Table Partitioning Concurrent Operations Native Partitioning was introduced in PostgreSQL 10 and performance improvements for improved parallel […] The post PostgreSQL 12…

newsdatadeveloper toolsplatform updatespostgres

Richard Schneeman 19 Dec 2019 7 min read

Update: On closer inspection, the lock type was not on the table, but on a tuple. For more information on this locking mechanism see the internal Postgresql tuple locking documentation. Postgres does not have lock promotion as suggested in the debugging section of this post. I maintain an internal-facing service at Heroku that does metadata […] The post The Curious…

engineeringdatabasedeveloper toolspostgres

Corey Purcell 28 Aug 2019 3 min read

As outlined in a previous blog post, Heroku Data services undergo routine maintenances for security and patching. In this post, we describe the process used to minimize downtime for Heroku Postgres and Heroku Redis premium ‘High Availability’ plans and how we optimized the process to perform up to 75% faster. Data Services Architecture High availability […] The post Up to…

engineeringdatabaseperformance optimizationpostgresredis

Becky Jaimes 15 Jul 2019 5 min read

Every organization needs to be data-driven in order to be successful. Whether you’re tracking an application’s performance, incoming support tickets, or revenue rates, different components of any company depend on metrics that inform the health of the business. At Heroku, we’re hackers to the core, but that doesn’t mean we’re all programmers. We build on […] The post Dataclips Power…

engineeringdatabasedeveloper toolsheroku dataclipspostgres

Jonan Scheffler 15 Apr 2019 10 min read

Setting up a database is a relatively straightforward process (Heroku has an add-on for that), but getting it to run well in production is sometimes another matter. As your application grows and your data grows along with it, you will likely find a number of performance bottlenecks specifically related to your database, and this post […] The post Optimizing Database…

engineeringdatabasedeveloper toolsperformance optimizationpostgres

Wade 26 Mar 2019 5 min read

There’s obviously more to security than humans, technology, and vendors with all of their implementations and expertise. At Heroku we believe that security is a byproduct of excellence in engineering. All too often, software is written solely with the happy path in mind, and security assurances of that software has its own dangerous assumptions. A […] The post Bug Bounties…

engineeringpostgressecuritysecurity incidents

Becky Jaimes 21 Mar 2019 3 min read

After a successful two-month Beta period, PostgreSQL 11 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 11 with the ease and usability of Heroku for building data-centric applications. We’d like […] The post PostgreSQL 11…

newsdatabasepostgressql

Camille Baldock 18 Jan 2018 3 min read

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 […] The post Heroku Postgres…

newsperformance optimizationplatform updatespostgres

Camille Baldock 14 Dec 2017 2 min read

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 […] The post PostgreSQL 10…

newsdatabasepostgressql

Camille Baldock 17 Oct 2017 3 min read

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 […] The post PostgreSQL 10…

newsdatabasepostgressql

Richard Schneeman 11 Jul 2017 9 min read

I recently demonstrated how you can use Rack Mini Profiler to find and fix slow queries. It’s a valuable tool for well-trafficked pages, but sometimes the slowdown is happening on a page you don't visit often, or in a worker task that isn't visible via Rack Mini Profiler. How can you find and fix those […] The post Using Heroku’s…

newsdatabaseperformance optimizationpostgresruby

Timothée Peignier 8 Dec 2016 3 min read

Postgres is our favorite database—it’s reliable, powerful and secure. Here are a few essential tips learned from building, and helping our customers build, apps around Postgres. These tips will help ensure you get the most out of Postgres, whether you’re running it on your own box or using the Heroku Postgres add-on. Use a Connection […] The post Making the…

newspostgres

Rimas Silkaitis 1 Dec 2016 4 min read

PostgreSQL 9.6 is now generally available for Heroku Postgres. The main focus of this release is centered around performance. PostgreSQL 9.6 includes enhanced parallelism for key capabilities that sets the stage for significant performance improvements for a variety of analytic and transactional workloads. With 9.6, certain actions, like individual queries, can be split up into […] The post PostgreSQL 9.6…

newspostgres

Rimas Silkaitis 13 Sept 2016 9 min read

One of the interesting patterns that we’ve seen, as a result of managing one of the largest fleets of Postgres databases, is one or two tables growing at a rate that’s much larger and faster than the rest of the tables in the database. In terms of absolute numbers, a table that grows sufficiently large […] The post Handling Very…

engineeringpostgres

Chris Castle 8 Sept 2016 2 min read

Austen Ito is a software engineer at leading online fashion brand Bonobos, based in New York. Read our Bonobos customer story for more information about how Heroku has helped their business. What do you have running on Heroku? We’re running just about everything on Heroku, including our Bonobos.com website, cross-app messaging services, an API for […] The post Running the…

newscustomerseducationjavascriptpostgres

Rimas Silkaitis 3 May 2016 2 min read

Starting today, Postgres 9.5 is now the new default version for all new Heroku Postgres databases. We’ve had hundreds of customers using early beta versions of 9.5 and the feedback has been positive. For many customers, the new UPSERT functionality was the last feature that prevented many of them from moving from other relational databases […] The post Postgres 9.5…

newsdatabasedeveloper toolsheroku postgrespostgres

Matthew Creager 7 Apr 2016 4 min read

We recently sat down for a chat with Bill Curtis, a co-founder and the CTO of Sweet Tooth (Now Smile.io), a points and rewards app for online stores worldwide. What has been your greatest challenge? We’re serving way more data today than we ever have, so scaling is mission-critical. In the past, we’ve struggled with […] The post Cyber Monday,…

newscustomerspostgresproduct featuresredis

Kenneth Reitz 24 Feb 2016 2 min read

A big update to the beloved Python web framework known as Django was released recently: Django 1.9. This release contains a long list of improvements for everything from the graphical styling of the admin to the ability to run your test suite in parallel. Our favorite improvements to the framework were, of course, all about […] The post Django 1.9’s…

newsdatabasedjangopostgresproduct features

Rimas Silkaitis 8 Jan 2016 3 min read

Heroku has long been committed to making PostgreSQL one of the best relational databases in the world. We’re also committed to giving you the ability to try the latest release as soon as it’s available. Today, we’re pleased to announce the public beta of Postgres 9.5 on Heroku. PostgreSQL 9.5 brings a bevy of super […] The post Here’s Postgres…

newsdatabasedeveloper toolsheroku postgrespostgres

Rimas Silkaitis 23 Apr 2015 1 min read

We’re pleased to announce PostgreSQL 9.4 in general availability for Heroku Postgres. After announcing the beta earlier this year, we’ve had many developers provision databases against this new version. Throughout the beta period, developers raved about the new data type along with the performance enhancements to materialized views. This uptake by early adopters demonstrates an […] The post PostgreSQL 9.4…

newspostgres

Rimas Silkaitis 12 Mar 2015 3 min read

Performing a backup is one of those tasks that ensures your application can recover from database or hardware failures should they ever occur. Over four year ago, we recognized this as a best practice and came out with PGBackups, an add-on that reduces the risk and complexity of taking database backups. Today, we’re pleased to […] The post Schedule PostgreSQL…

newsdatabasedeveloper toolspostgres

Peter van Hardenberg 8 Jan 2015 3 min read

Each major release of PostgreSQL brings lots of great new functionality. The recent release of PostgreSQL 9.4 includes an exciting new JSON data type, improvements to window functions, materialized views, and a host of other performance improvements and enhancements. We’ll go into more depth on what’s new and exciting in this release below, but first, […] The post PostgreSQL 9.4…

newsdatabasedeveloper toolsheroku postgrespostgres

Scott Persinger 17 Jul 2014 4 min read

Heroku Connect is a service offered by Heroku which performs 2-way data synchronization between Salesforce and a Heroku Postgres database. When we first built Heroku Connect, we decided to use polling to determine when data had changed on either side. Polling isn’t pretty, but its simple and reliable, and those are “top line” features for […] The post Heroku Connect:…

engineeringdeveloper toolsheroku connectpostgressalesforce

Matthew Soldo 12 Jun 2014 3 min read

Did you know that Heroku databases can be forked? Forking a database creates a byte-for-byte copy that can be used for testing and development. It is a useful tool that allows teams to be agile with their data. Today, forking databases is becoming faster. Fast forking reduces the time to create a fork by hours […] The post Faster Database…

newspostgres

Harold Giménez 28 Nov 2013 1 min read

On November 18th, a replication bug was found in Postgres that affected the most recent versions of every Postgres release. The corruption that this bug may introduce could go undetected, and it manifests itself as a follower potentially having an inconsistent view of the data. For example, data could be present in the primary and […] The post Heroku Postgres…

newspostgres

Craig Kerstiens 22 Nov 2013 2 min read

Many of our customers have recently asked about our connection limit settings on our new Heroku Postgres tiers. Previously we allowed for 500 connections across all production databases, however now there is some variance in the number of connections allowed with only the larger plans offering 500. In individual conversations with customers we’ve detailed the […] The post Postgres Connection…

newspostgres

Craig Kerstiens 14 Nov 2013 1 min read

At Heroku we have long considered PostgreSQL to be a powerful and reliable open-source database for keeping data safe and accessible for serious applications with demanding workflows and use cases. Over the years we’ve invested heavily in continuing to improve it, whether it’s by employing Postgres major contibutors, employing driver maintainers, funding core development, or […] The post Welcome to…

newspostgres

Craig Kerstiens 11 Nov 2013 4 min read

Today we’re excited to announce an evolution of what it means to be a database as a service provider. Along with new features such as the ability to roll back your database to an arbitrary point in time and high availability, we now provide an entirely new level of operational expertise that’s built right in. […] The post Introducing Heroku…

newspostgres

Craig Kerstiens 7 Nov 2013 1 min read

Several weeks ago we added support for Postgres 9.3 in public beta the day it was released to the community. We've had many customers use it so far and it has proven to be robust and reliable. Early adopters have started to take advantage of the great new features in this version including: New JSON […] The post PostgreSQL 9.3…

newspostgres