Pganalyze Blog RSS Feed
Monitoring Postgres and tuning query performance
Aktualisiert: vor 19 Minuten 32 Sekunden
Waiting for Postgres 19: Reduced timing overhead for EXPLAIN ANALYZE with RDTSC
In today’s E122 of “5mins of Postgres” we're talking about the upcoming Postgres 19 release, and how a change in the Postgres instrumentation handling reduces overhead of timing measurements in EXPLAIN ANALYZE using the RDTSC instruction, and why this will allow turning on auto_explain.log_timing for more workloads.
The Dilemma of the ‘AI DBA’
Like many in the industry, my perspective on AI tools has shifted considerably over the past year, specifically when it comes to software engineering tasks. Going from “this is nice, but doesn’t really solve complex tasks for me” to “this actually works pretty well for certain use cases.” But the more capable these tools become, the sharper one dilemma gets: you can hand off the work, but an AI agent won’t ultimately be responsible when the database goes down and your app stops working.
