Creative ideas for speeding up queries in PostgreSQL

We are releasing Agent Skills for Postgres Best Practices to help AI coding agents write high quality, correct Postgres code.

Agent Skills to help developers using AI agents with Supabase - supabase/agent-skills

Maybe busy systems change the behavior and high maintenance_work_mem values would win?

Deep dive into PostgreSQL arrays: why they're document storage in disguise, the TOAST performance trap, GIN vs B-tree indexing, the dangerous ANY() operator, and when junction tables beat arrays.

pgpm - A Postgres Package Manager for Modular Postgres Development. Modern CLI for modular PostgreSQL development with reusable database packages, deterministic migrations, recursive dependency resolution, tag-aware versioning, and turnkey module-first workspaces.

I had a typical web app stack: PostgreSQL for persistent data Redis for caching, pub/sub, and...

PostgreSQL 18 has arrived with some fantastic improvements, and among them, the RETURNING clause enhancements stand out as a feature that every PostgreSQL developer and DBA should be excited about. In this blog, I'll explore these enhancements, with particular focus on the MERGE RETURNING clause enhancement, and demonstrate how they can simplify your application architecture and improve data tracking capabilities.

I have been working on a double-entry ledger implementation in PostgreSQL called pgledger, and I wanted to write some example scripts. pgledger is written in SQL and meant to be used from any language or platform where you can call SQL functions, so I wanted the examples to be pure SQL.

MCP server and Claude plugin for Postgres skills and documentation. Helps AI coding tools generate better PostgreSQL code. - timescale/pg-aiguide

こんにちは。 アプリケーションサービス、DevOps担当の兼安です。 AWS re:Invent 2025でAmazon Aurora PostgreSQL(以降、Aurora PostgreSQLと書きます)の動的データマスキングが発表されました。 今回はこれを機会に、行レベルセキュリティ（Row-Level Sec…

Learn how to clone PostgreSQL databases instantly using reflinks. Turn slow template copies into milliseconds with PostgreSQL 18's new file copy options.

Deploy More Resilient Apps. Hatchet is a platform for building distributed web apps that solves scaling problems like concurrency, fairness, and rate limiting.

Introducing faceted search in ParadeDB - bringing the power of search engine faceting to PostgreSQL with single-query aggregations.

Postgres 18 defaults to checksums on. This is a good feature for data integrity but might catch you off guard with an upgrade.

Rebuilding indexes after an operating system upgrade is painful. Learn how to rebuild only those indexes that really need it!

PostgreSQL extension for BM25 relevance-ranked full-text search. Postgres OSS licensed. - timescale/pg_textsearch

PostgreSQL VACUUM cleans tables but leaves indexes bloated. Learn why B-trees fragment and how to fix them properly.

Learn to tune the PostgreSQL logs for debugging and performance and switch to structured JSON for modern observability

Learn how UUIDv7 in PostgreSQL reduces conflicts in data management and why it increases efficiency.

How PostgreSQL scales in real-world systems, compared with MongoDB, and why true scalability depends on design and workloads, not headlines.

Explore how to build an AI coding agent that follows a full developer workflow, including creating Postgres branches, using a sandbox, fixing bugs, and raising pull requests with Xata, Vercel, and GitHub.

In this blog, we explore Postgres constraints through the pg_constraint catalog, covering table vs. column constraints, constraint triggers, domains and more.

What is a sequential scan vs index scan vs parallel scan .... and what is a bitmap heap scan? Postgres scan types explained and diagrammed.

PostgreSQL backup tool. Contribute to RostislavDugin/postgresus development by creating an account on GitHub.

Free and open source tool for PostgreSQL scheduled backups. Save them locally and to clouds. Notifications to Slack, Discord, etc.

Enterprise-grade PostgreSQL backup and restore. Beautiful CLI with real-time progress tracking.