PostgreSQL 19 introduces the REPACK command, merging VACUUM FULL and CLUSTER functionality to combat table bloat.
PostgreSQL 19 will allow excluding specific tables from logical replication publications using the new EXCEPT TABLE syntax.
PostgreSQL 19 adds non-text output formats to pg_dumpall, enabling parallel restore and selective database restoration from cluster-wide backups.
New PostgreSQL 18 and SQLite features allow developers to copy database statistics to test production query plans without moving large datasets.
New PostgreSQL 18 and SQLite features allow developers to copy database statistics to replicate production query plans in dev environments.
A retrospective on the Marten .NET library's growth over five years, covering adoption drivers like commercial support and documentation improvements.
Explores change-driven architecture on Azure using Drasi to replace polling with Change Data Capture for real-time, efficient data processing.
Guide on connecting PostgreSQL to Dremio Cloud for federated queries, analytics acceleration, and building a semantic layer without data movement.
![[Video] Office Hours at Atlantis, Bahamas](https://alldevblogs.blob.core.windows.net/thumbs/article-62b73516f150-full-71f9446b.webp)
Brent Ozar answers top-voted SQL Server questions from the community in a video Q&A session recorded in the Bahamas.
Compares how Oracle and PostgreSQL uniquely identify SQL queries and execution plans, focusing on SQL_ID vs query_id and PLAN_HASH_VALUE vs query_hash.
Analysis of corporate contributions to the latest PostgreSQL 18 release, ranking companies by commits, code changes, and number of contributors.
Explains how to display PostgreSQL timestamps with a specific timezone offset, including a custom function solution.
![[Video] Office Hours in Tokyo, Japan](https://alldevblogs.blob.core.windows.net/thumbs/article-14278cd3a80f-full-1eb1b061.webp)
Brent Ozar answers SQL Server, Azure SQL, and database management questions from viewers during an informal 'Office Hours' session in Tokyo.
Explores creative PostgreSQL optimization techniques beyond standard indexing and query rewriting, focusing on constraint exclusion and function-based indexes.
A developer recounts debugging a PostgreSQL container stability issue that turned out to be a hidden security vulnerability, sharing lessons learned.
A developer creates a simple, AI-assisted Node.js tool for automatically loading CSV files into PostgreSQL with minimal configuration.
Author details a fix for suboptimal indentation in complex SQL join conditions within the paste.depesz.com query pretty-printer.
A technical analysis measuring the performance impact of adding indexes on write operations (COPY) in PostgreSQL, showing slowdowns and size overhead.
PostgreSQL 19 introduces new ALTER TABLE commands to MERGE and SPLIT partitions, with initial single-process, locked implementations.
Analysis of a complex RCE attack chain in PostHog exploiting SSRF, a ClickHouse SQL 0day, and default PostgreSQL credentials.
