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.
I could spin up an Amazon EC2 instance and install PostgreSQL myself, review latest configuration best practices, sort Amazon EBS storage for data, set up a snapshot process etc.
Alternatively I could use Amazon RDS, Amazon RDS for PostgreSQL or Heroku Postgres and have most of that work handled for me, by a team of world experts...
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.
Stores the admin database for the SRX apps - includes an audit log, error tracking, and SRX admin message log.
Will also store PRS rules when refactor is complete. Heroku Postgres
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