Heroku Postgres is Heroku’s database-as-a-service running an unmodified PostgreSQL installation. If you’re looking for Heroku Postgres' current plans please visit the pricing page. The below pertains to the legacy plans for Heroku Postgres. These legacy plans are still available and provisionable, but not listed in
heroku addons:list or within dashboard provisioning.
The legacy plans consist of two tiers, starter and production, across a variety of plans.
||Free and low-cost database plans for evaluation, application development, and testing.|
||Production-grade monitoring, operations, and support.|
The starter tier database plans are not intended for production-caliber applications or applications with high-uptime requirements.
The starter tier, which includes the
plans, has the following
- Enforced row limits of 10,000 rows for
devand 10,000,000 for
- Max of 20 connections
- No in-memory cache: The lack of an in-memory cache limits the performance capabilities since the data can’t be accessed on low-latency storage.
- No fork/follow support: Fork and follow, used to create replica databases and master-slave setups, are not supported.
- Expected uptime of 99.5% each month
- No postgres logs
As the name implies, the production tier of Heroku Postgres is intended for production applications and includes the following feature additions to the starter tier:
- No row limitations
- Increasing amounts of in-memory cache
- Fork and follow support
- Max of 500 connections
- 1 TB of storage (if you need beyond 1 TB please contact us)
- Expected uptime of 99.95% each month
- Database metrics published to application log stream for further analysis
Management of production tier database plans is also much more robust including:
- Eligible for automatic daily snapshots with 1-month retention (see the PGBackups add-on for more details)
- Priority service restoration on disruptions
Non-production applications, or applications with minimal data
storage, performance or availability requirements can choose between
one of the two starter tier plans,
basic, depending on row
requirements. However, production applications, or apps that require
the features of a production tier database plan, have a variety of
plans to choose from. These plans vary primarily by the size of their
in-memory data cache.
The cache and price for each legacy production plan is:
|Plan Name||Provisioning name||Memory||Price per month|