GitHub - ankane/pghero: A performance dashboard for Postgres

Fix slow Rails apps in 5 steps. Guide covers N+1 queries, missing indexes, memory bloat, view rendering & asset compilation with real-world examples.

A guide to configuring PostgreSQL auto_explain, including advice on how to best set it up for use with pgMustard.

Radan here: this is another guest post by Miha. He was so excited about it that he interrupted my weekend with a brand new post to review. I still found it interesting, so I hope you enjoy it as much as I did! Back to Miha now.

Postgres is Enough . GitHub Gist: instantly share code, notes, and snippets.

I use PostgreSQL heavily, and I freaking love it, so I am writing down things that I refer to frequently.

Ruby on Rails Engines is one of the most powerful and underestimated features. Here are some of my favorite ones.

Open Source at Instacart

PostgreSQL General Articles Mistakes to avoid while using PostgreSQL The Part of PostgreSQL We Hate the Most We are sticking with postgresql Free Postgres database (or SQLite) from fly.io Using generate_series feature for reporting When Postgres blocks: 7 tips for dealing with locks PostgreSQL - Don’t do this Is PostgreSQL good enough? Online event processing by Martin Klepmann PostgreSQL rocks, except when it blocks: Understanding locks Connection handling best practice with PostgreSQL 10 Things I Hate About PostgreSQL PostgreSQL - Advanced Administration by Bruce Momjian Top Tools and Recommendations to Manage Postgres in an Enterprise: Administration, Performance, High Availability, and Migration Using PostgreSQL as Cache and Read Optimization tips Adyen’s Use of PostgreSQL PostgreSQL version Upgrade @ Gitlab Zombodb - PostgreSQL and ElasticSearch work together Using pg_timetable for job scheduling Using pg_cron to schedule background tasks Using pg_cron to roll up for Analytics PG Database Configuration Helper Full text search in PostgreSQL Postgres full text search capabilities Full text search (Crunchydata) PostgreSQL - Best practices(Azure) Designing high performance time series data table in (RDS) postgresql while using BRIN Index Informative blog on PostgreSQL Understanding GIN indexes PostgreSQL - Using SQL for Data Analysis Approach to Bulk Import in PostGreSQL Schema updates with zero downtime in PostgreSQL How to JSON in PostgreSQL Grouping, Rollups and Cubes Row level Security Just use postgres Performance tuning, configuration PostgreSQL Toast and why it matters Scaling postgresql - Practical Tips pgassistant - insights into database behavior, identifies schema-related issues, and assists in correcting them Partitioning as Query Optimization Strategy Database Configuration Builder Configuration for Diagnosing Performance issues OrioleDB- Solving Wicked problems of PostgreSQL 5 Minutes in PostgreSQL - Videos PostgreSQL Tips Optimizing AutoVaccum in Pos

Delve into best practices for HTTP, Ruby on Rails, and databases, and discover when to adhere to the rules or when breaking them could set your code apart.

Last week's article, Super Fast Rails, received many funny reactions. But for some people, that was too much.

It’s been over 2 years since PgHero 1.0 was released as a performance dashboard for Postgres. Since then, a number of new features have been added....

Many companies start out with a single web application. As the team and codebase grow, things feel less organized and common tasks like booting the...

My side project Abot for Slack, has been around for ~7 years, i.e., since Rails 5.1. It's now yielding passive income while running on an almost complete autopilot. But I'm still keeping its dependencies up-to-date. The recent migration to Rails 8 was arguably the most impactful in the app's lifetime. In this blog post, I'll describe features introduced in the newest version of the framework and how they affected my project.