PostgresFMNew episode: "Long-running transactions"
Nik and Michael discuss long-running transactions, including when they're harmless, when they cause issues, and how to mitigate those issues.
| Personal site | https://michristofides.com/ |
Michael Christofides
- 157 Followers
- 177 Following
- 428 Posts
I run @pgmustard, host @postgresfm, enjoy bad jokes, and wear questionable jumpers 💙💛
New episode: "PostGIS"
Nik and @michristofides are joined by @robe and @pwramsey to discuss PostGIS.
Marco ArmentI have been a Macintosh user for quite some time now and I have never, not once, not a single time, correctly distinguished "brew update" from "brew upgrade" on the first try
New episode: "pg_ash"
Nik and Michael discuss pg_ash — a new tool (not extension!) from Nik that samples and stores wait events from pg_stat_activity.
pgMustardpgMustard Pro now includes 1,000 API credits 🎉
Bulk-analyse plans, plug into your LLM workflows, or build something we haven't thought of yet.
New episode: "Comments and metadata"
Nik and Michael discuss query level comments, object level comments, and another way of adding object level metadata.
New blog post: Read efficiency issues in Postgres queries
If you've got a query that's slowly degrading in performance over time, you might have a read efficiency issue. The root cause could be table bloat, index bloat, or data locality degradation. In this new post we go through how this can happen, how to mitigate the issue, and the options for preventing it happening again.
https://www.pgmustard.com/blog/read-efficiency-issues-in-postgres-queries
Read efficiency issues in Postgres queries - pgMustard
A lot of the time in database land, our queries are I/O constrained. As such, performance work often involves reducing the number of page reads. Indexes are a prime example, but they don’t solve every issue (a couple of which we’ll now explore).
Carlton GibsonDesign and critical thinking have always been the bottlenecks people. (Pass it on!)
New episode: "PgDog update"
Nik and Michael are joined by Lev Kokotov for an update on all things PgDog.
Our Read Efficiency tips are now more efficient to read!
📝 Better wording, mostly for clarity
🔬 More specific to the scan type, and therefore shorter in most cases
🌟 Improved scoring, especially for Bitmap Heap Scans
More details: https://www.pgmustard.com/changelog
