Voxox CloudPhone mentions (0)

PgHero mentions (8)

• How to Get the Most Out of Postgres Memory Settings

  For our production PGSQL databases, we use a combination of PGTuner[0] to help estimate RAM requirements and PGHero[1] to get a live view of the running DB. Furthermore, we use ZFS with the built-in compression to save disk space. Together, these three utilities help keep our DBs running very well. [0] https://pgtune.leopard.in.ua [1] https://github.com/ankane/pghero. - Source: Hacker News / 26 days ago

• Show HN: PostgreSQL Index Advisor

  I am using https://github.com/ankane/pghero/ and this is one of its features with GUI. - Source: Hacker News / 3 months ago

• What are your favourite approaches to keeping on top of Postgres health?

  I use either PgHero or Rails PG Extras on every project. Source: about 1 year ago

• Slow query. Should add indexes?

  There are tools available which can look at your Postgres logs and tell you if you need to add indexes, I've used https://github.com/ankane/pghero before and it seems decent. Source: about 1 year ago

• How and why Relational Model works for databases

  I'm a huge supporter of PGhero (https://github.com/ankane/pghero) for this reason. Sometimes a single index is all that's required, but if DB design isn't your forte it's hard to know where to put it. - Source: Hacker News / over 2 years ago