proomt

Search

Search posts, papers, and topics

All posts

PostgreSQLDasha4 min readrelease notesintermediate

Dasha 1.8: index recommendations, I/O analysis, schema checks and log insights

Read on postgresql.org

Summary

Dasha 1.8, an open-source PostgreSQL performance dashboard, introduces automated index recommendations, detailed I/O analysis, and 17 schema checks. It also adds log insights with external log source integration and per-database query analysis, enhancing fleet monitoring and proactive issue detection.

  • Automated index recommendations propose B-tree indexes based on pg_stat_statements and auto_explain plans.
  • Detailed I/O page built on pg_stat_io (PostgreSQL 16+) breaks down server I/O by type, object, and context.
  • 17 schema checks identify structural defects like sequences near exhaustion, missing primary keys, and unlogged relations.
  • Log insights integrate with OpenSearch/Elasticsearch to group events and analyze auto_explain plans for regressions.

Database administrators and SREs managing PostgreSQL fleets will find these features crucial for proactive performance tuning, identifying potential issues, and improving operational efficiency.

7/10
devopsobservabilityperformancedatabasesmonitoringpostgresql

Related reading

  2. pgAssistant 3.8.0 : continuous improvement loop for Postgres

    pgAssistant 3.8.0 expands from a tuning advisor to a continuous PostgreSQL improvement platform, adding a Collector that records historical workload and environment data. It lets teams run an Observe‑Diagnose‑Prioritize‑Plan‑Implement‑Measure loop, compare consecutive snapshots, and measure the impact of applied recommendations.

    PostgreSQLpostgresql.org1 minrelease

  3. Knowing When Your Composite Index Earns Its Write Cost

    This guide explains how to evaluate the trade-off of adding a composite index in PostgreSQL by quantifying its read benefits and write costs. It provides a method to measure the impact on ingest throughput and decide if the index earns its overhead based on your system's peak ingest ceiling.

    Timescaletigerdata.com8 min

  4. PostgresCompare 2.2.0 Released

    PostgresCompare 2.2.0 is a major rewrite (Electron → Tauri) that adds pipelines, quick compare, data‑change scripting, an MCP server for AI‑driven migrations, parallel connections, and a CLI for schema export. UI is restyled, multilingual, and self‑updating. Supports PostgreSQL 9.2‑18 on Windows, macOS, Linux.

    PostgreSQLpostgresql.org3 minrelease

  5. Introducing TIN: full-text search for Postgres

    PlanetScale’s TIN is a new PostgreSQL extension that implements a full‑text search index supporting Boolean, phrase, span, fuzzy, wildcard, regex, case/accent folding, COUNT(*) and BM25 top‑k queries. In a suite of benchmarks on an i7i.8xlarge EC2 instance (8 vCPU, 32 GB RAM), TIN built in 8 min 10 s (50.7 GB index) and outperformed ParadeDB, pg_textsearch and the built‑in GIN index by large marg…

    PlanetScaleplanetscale.com15 minHN20175

  6. ARIES: A Transaction Recovery Method Supporting Fine-Granularity Locking and Partial Rollbacks Using Write-Ahead Logging

    ARIES is a transaction recovery method using write-ahead logging (WAL) that supports fine-granularity locking and partial rollbacks. It introduces the "repeating history" paradigm to redo all missing updates before performing rollbacks of loser transactions during system restart, using Log Sequence Numbers (LSNs) on pages.

    Hall of Famestanford.edu155 minpaper