Tips for a Healthier Postgres Database

This page summarizes the projects mentioned and recommended in the original post on news.ycombinator.com

Our great sponsors
  • PopRuby - Clothing and Accessories for Ruby Developers
  • WorkOS - The modern identity platform for B2B SaaS
  • InfluxDB - Power Real-Time Data Analytics at Scale
  • PgHero

    A performance dashboard for Postgres

    If you are using rails, pghero is a great gem to get better visibility on your Postgres performance

    https://github.com/ankane/pghero

  • postgres_exporter

    A PostgreSQL metric exporter for Prometheus

    New server and want a basic config for a production server? (I'm assuming brand new app here, no prior monitoring and knowledge on what to tune.)

    Use this to get the values you need https://pgtune.leopard.in.ua/#/ .

    This saved me a lot of headaches, and it just gets the server into a good enough state from which you can observe and optimise later.

    I'd also add in monitoring early, add a Prometheus exporter https://github.com/prometheus-community/postgres_exporter and alerts https://awesome-prometheus-alerts.grep.to/rules#postgresql . There are a few Grafana dashboards available for the prometheus exporter, start with those.

  • PopRuby

    PopRuby: Clothing and Accessories for Ruby Developers. Fashion meets Ruby! Shop our fun Ruby-inspired apparel and accessories designed to celebrate the joy and diversity of the Ruby community.

NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a more popular project.

Suggest a related project

Related posts