What is Heroku Postgres?
Who uses Heroku Postgres?
Heroku Postgres Integrations
Why developers like Heroku Postgres?
Here are some stack decisions, common use cases and reviews by companies and developers who chose Heroku Postgres in their tech stack.
PostgreSQL Heroku Heroku Postgres Node.js Knex.js
Last week we rolled out a simple patch that decimated the response time of a Postgres query crucial to Checkly. It quite literally went from an average of ~100ms with peaks to 1 second to a steady 1ms to 10ms.
However, that patch was just the last step of a longer journey:
I looked at what API endpoints were using which queries and how their response time grew over time. Specifically the customer facing API endpoints that are directly responsible for rendering the first dashboard page of the product are crucial.
I looked at the Heroku metrics such as those reported by
heroku pg:outlierand cross references that with "slowest response time" statistics.
I reproduced the production situation as best as possible on a local development machine and test my hypothesis that an composite index on a
uuidfield and a
timestampzfield would reduce response times.
This method secured the victory and we rolled out a new index last week. Response times plummeted. Read the full story in the blog post.
We migrated from Heroku Postgres to Amazon RDS for Aurora not long ago. The driving force behind the migration was the increased performance and cloud tuned PostgreSQL instances. Pricing was also a factor, as RDS delivers more value for the price. We have a staging and production cluster that can be scaled up or down as we need capacity. Snapshots, backups, and maintenance are handled automatically, though the timeframes are configurable. They offer automatic failover, and multi-az replication #StackDecisionsLaunch
We use heroku PostgreSQL databases for testing alongside our sandboxed application(s) in heroku.
Extremely simple, practically a one-click setup. Heroku Postgres
Created several tables for users, brands, deals, campaigns, and tracking. Heroku Postgres
Heroku Postgres's features
- High Availability
- Automated Health Checks