Heroku Postgres Essential Tier (Public Beta)
Last updated May 01, 2024
The beta release is available for customers interested in the newest Heroku Postgres Essential-tier plans. On improved infrastructure, the new plans no longer have a row limit and also support the pgvector
extension. This beta gives customers an early opportunity to experiment and provide feedback that helps guide us toward delivering world-class, user-centric database services.
The Heroku Postgres Essential tier is currently in public beta. The products offered as part of the beta aren’t intended for production use and are considered as a Beta Service and are subject to the Beta Services terms at https://www.salesforce.com/company/legal/agreements.jsp.
This public beta doesn’t cover the existing mini
and basic
plans. See Plan Details for the beta plans.
Beta Details
- It’s free to participate and use the new Essential-tier products. To submit feedback on the new plans, open a support ticket and use the subject line
Heroku Postgres Essential Beta Feedback: <feedback>
. If you have any questions or concerns, use the subject lineHeroku Postgres Essential Beta Support: <issue>
in your support ticket. - We reserve the right to shut down the test databases and the public beta at any point for any or no reason.
- After the beta period, we start charging for all Essential-tier databases. If you don’t want to use these plans after GA, you can migrate to a different plan or remove your add-on.
Getting Started
Provision the Database
These plans are available through the dashboard and the CLI. Use this command to provision a database through the CLI.
$ heroku addons:create heroku-postgresql:essential-1 --app example-app
To see the details of your database, use the pg:info
command:
$ heroku pg:info -a example-app
=== HEROKU_POSTGRESQL_RED
Plan Essential 1
Status available
Data Size 2.8 GB
Tables 13
PG Version 15
Created 2024-03-01 09:58 PDT
…
Plan Details
The beta Essential-tier plans are available on Postgres versions 16, 15, and 14. The beta introduces three new plans in the Essential tier, with expected general availability (GA) starting in May:
Product | Provisioning Name | Disk | Connection Limit | Row Limit | Table Count Limit | Status | Pricing After GA |
---|---|---|---|---|---|---|---|
Essential-0 | heroku-postgresql:essential-0 |
1 GB | 20 | No limit | 4,000 | Beta | ~$0.007/hour (Max of $5/month) |
Essential-1 | heroku-postgresql:essential-1 |
10 GB | 20 | No limit | 4,000 | Beta | ~$0.012/hour (Max of $9/month) |
Essential-2 | heroku-postgresql:essential-2 |
32 GB | 40 | No limit | 4,000 | Beta | ~$0.027/hour (Max of $20/month) |
Work With Your Database
The beta Essential-tier plans support the shared features in all Heroku Postgres plans except for versions supported.
Install Extensions
The beta Essential-tier plans support all the extensions listed in Extensions, PostGIS, and Full Text Search Dictionaries on Heroku Postgres.
Upgrade Your Plan
addons:upgrade
You can upgrade your existing mini
and basic
databases to the beta Essential-tier plans with addons:upgrade
. The upgrade starts immediately without waiting for or running a scheduled maintenance.
$ heroku addons:upgrade heroku-postgresql:essential-0
pg:copy
You can migrate data from your existing mini
and basic
databases to the beta Essential-tier plans with pg:copy
. Make sure the table count in your existing database is within the plan limits before upgrading. To find your table usage, run the pg:info
command.
Upgrade Your Version with pg:upgrade
You can upgrade your beta Essential-tier database’s major PostgreSQL version with pg:upgrade
by running the command directly on your database.
$ heroku pg:upgrade HEROKU_POSTGRESQL_RED --app example-app
You can specify the version that pg:upgrade
uses with the --version
flag, for example, --version 14
. If you don’t set the --version
flag, the upgrade defaults to the latest Postgres version.
Back Up Your Data with PGBackups
You can create manual backups or schedule backups with PGBackups. Beta Essential databases have the following limits on manual and scheduled backups.
Plan | Manual Backups Retained | Scheduled Daily Backups Retained | Scheduled Weekly Backups Retained | Scheduled Monthly Backup Retained |
---|---|---|---|---|
Essential-* | 5 | 7 days | 1 week | 0 months |
Run Diagnostics with pg:diagnose
You can perform useful health and diagnostic checks that help analyze and optimize database performance with pg:diagnose.
Create and Share Dataclips
You can create SQL queries on your databases and share the results with Dataclips.
Plan Limit Enforcement
Plan limits are enforced with the following mechanism:
- When a beta Essential database reaches 90% of a usage limit, the owner receives a warning email.
- When the database exceeds a limit, the owner receives an additional notification. At this point, the database receives a 7-day grace period to comply with the limit or migrate to another plan.
- If the database is still exceeding any plan limits after 7 days, we revoke
INSERT
andUPDATE
privileges and we limit the number of connections to 1 on the database. You can still read, update, or delete data from the database so that you can bring your database into compliance and retain access to your data. - If the database is still exceeding in violation of our policy, we remove all connections for an additional 7 days. The owner must create a support ticket to regain access to the database.
- When the usage is again in compliance with the plan limit, we automatically restore privileges and connections to the database. Restoring privileges can take some time. If the usage continues to exceed the plan limit, we flag the database for deletion due to non-compliance to our policy.