PostgreSQL
Latest PostgreSQL news, announcements & analysis
Data
Safely Test Database Indexes Before You Build Them
A new version of HypoPG, a PostgreSQL extension, is now available. It lets developers see how a new database index would perform without the costly process of actually building it, making performance tuning much safer and faster.
Taranpreet Singh ·
Data
PostgreSQL Tool Simplifies Major Database Upgrades
The latest update to pg_ivm, a PostgreSQL performance tool, simplifies major database upgrades and fixes key data correctness bugs. This makes managing high-performance materialized views more reliable and straightforward for developers and DBAs.
Taranpreet Singh ·
Data
A Better Way to Find PostgreSQL Slowdowns
A major update to pgCluu, a free PostgreSQL performance tool, is now available. It helps teams find and fix database slowdowns with new, more detailed reports on disk activity and support for the latest PostgreSQL versions.
Taranpreet Singh ·
Data
How OpenReplay Ditched Postgres for Massive Scale
Observability platform OpenReplay switched from Postgres to ClickHouse to manage billions of daily user events. The new system handles up to 6 TB of data per day on a single server, enabling sub-second analytical queries.
Taranpreet Singh ·
Data
PostgreSQL Drops Support for Older RHEL Versions
PostgreSQL is retiring its software repositories for RHEL 10.0 and 9.6. Systems on these versions, including Rocky and AlmaLinux derivatives, will stop receiving updates and security patches unless administrators take action.
Taranpreet Singh ·
Data
Take More Control of Your PostgreSQL Queries
A popular PostgreSQL extension, pg_hint_plan, just released a major update. It gives developers more direct control over how the database runs queries, adding new tuning strategies and preparing for the upcoming PostgreSQL 19.
Taranpreet Singh ·
Data
PostgreSQL Email Tool Gets a Major Security Upgrade
A popular PostgreSQL extension for sending emails directly from the database now supports encrypted connections and asynchronous sending. The update makes it a more secure and performant option for developers, especially those migrating applications from Oracle.
Taranpreet Singh ·
Data
The Next Major PostgreSQL Version Is Almost Here
The first release candidate for PostgreSQL 19 is now available, signaling the final testing phase before its official launch. This major update brings significant performance and feature enhancements for developers and data teams.
Taranpreet Singh ·
Data
New Tool Brings Version Control to PostgreSQL Schemas
A new open-source tool, Perseid, brings Git-like version control to PostgreSQL database schemas. It helps development teams track, manage, and deploy database changes more reliably, reducing errors and improving collaboration on complex projects.
Taranpreet Singh ·
Data
New Tool Treats Your Postgres Schema Like Code
A new open-source tool, pglifecycle, lets developers manage PostgreSQL schemas declaratively using version-controlled YAML files. This approach aims to replace traditional, complex migration scripts, making database changes easier to review and deploy in modern CI/CD pipelines.
Taranpreet Singh ·
Data
One Password Could Compromise Your Entire Postgres DB
A critical security flaw in PgBouncer, a popular PostgreSQL tool, allows an attacker with one user's password to log in as any other user, including administrators. The new 1.26.1 release fixes this and two other vulnerabilities.
Taranpreet Singh ·
Data
PostgreSQL Vector Search Just Got Much Faster
A new open-source extension for PostgreSQL called pg_vectorsearch dramatically improves vector search performance. It uses a novel index to deliver faster queries with significantly less memory, making AI applications more efficient and affordable.
Taranpreet Singh ·
Data
Stop Dangerous PostgreSQL Queries Before They Run
A new open-source tool for PostgreSQL, pg_plan_filter, automatically blocks potentially harmful or expensive queries from running. This helps prevent database slowdowns and instability in production environments, acting as a preventative guardrail for your data.
Taranpreet Singh ·
Data
Google Makes Advanced AI Search Radically Simple
Google updated its AlloyDB database to combine two types of search—vector and full-text—into a single command. This drastically simplifies building high-quality search for modern AI applications, reducing complexity and improving performance for developers.
Taranpreet Singh ·
Data
A Key Postgres Extension Just Got More Stable
The pg_ivm extension for PostgreSQL, which speeds up data views, has a new version. The update fixes a critical crash bug and adds future support for PostgreSQL 19, making it more reliable for production use.
Taranpreet Singh ·
Data
One Bad Query Crashed These Postgres Databases
A new benchmark tested how major PostgreSQL providers handle memory-intensive queries. The test revealed that some popular services, including AWS RDS and Google Cloud SQL, crashed completely, causing significant downtime.
Taranpreet Singh ·
AI
AI Agents Get Their Own Disposable Databases
pgEdge launched Starfleet, a Postgres platform that gives AI coding agents their own isolated database branches. These branches are never merged, letting developers safely test AI-generated code without risking their main production database.
Neeraj Dhiman ·
Data
pgEdge Wants to Solve Your AI Scaling Problem
Database firm pgEdge has launched Starfleet, a new service to help developers move AI applications using Postgres from the prototype stage to full-scale production, addressing a common point of failure for many AI projects.
Taranpreet Singh ·
Data
Unauthenticated Attackers Can Crash Your Database Pooler
A new version of PgBouncer, the popular PostgreSQL connection pooler, has been released to fix three critical security flaws. Two of the vulnerabilities allow unauthenticated attackers to crash the service, making this an urgent update for all users.
Taranpreet Singh ·
Data
Replace Your Workflow Engine with Just Postgres
A new architectural pattern shows how developers can use standard Postgres features to manage complex, durable workflows. This eliminates the need for external orchestration tools, simplifying infrastructure and potentially lowering operational costs for engineering teams.
Taranpreet Singh ·
Data
Google's Postgres Database Now Searches 10 Billion Vectors
Google's AlloyDB now supports searching up to 10 billion vectors, a massive jump in scale. This allows developers to build enterprise-grade AI applications on a fully managed, PostgreSQL-compatible database without hitting previous performance limits.
Taranpreet Singh ·
Data
Explore Your PostgreSQL Database as a 3D City
A new open-source tool called PGSimCity visualizes complex PostgreSQL operations as an interactive 3D city. It helps developers and engineers intuitively understand how their database works internally, making a complex system easier to grasp.
Taranpreet Singh ·
Data
Critical PostgreSQL Update Fixes 28 Security Flaws
The PostgreSQL team has released a critical security update for all supported versions, patching 28 vulnerabilities and over 110 bugs. This major release requires immediate attention from anyone running a PostgreSQL database to prevent potential exploits.
Taranpreet Singh ·
Data
PostgreSQL Tool Lowers Risk With Granular Permissions
E-Maj, a PostgreSQL extension for database management, released version 5.0.0. It now allows non-superusers to use the tool, significantly improving security by limiting administrator privileges and simplifying automated scripting for developers.
Taranpreet Singh ·
Data
Postgres Backups Get a Major Hybrid Cloud Boost
The popular PostgreSQL backup tool pgBackRest now supports AWS S3 Outposts, making it easier to manage backups in hybrid cloud environments. The update also adds support for the upcoming PostgreSQL 19, helping teams prepare for the future.
Taranpreet Singh ·
Data
Now You Can Run Ruby Inside Your Database
A new open-source tool called plRuby lets developers write and run functions inside PostgreSQL using the Ruby language. This simplifies database logic for Ruby developers and can significantly speed up development cycles.
Taranpreet Singh ·
Data
Keep Your Old PostgreSQL Database Secure for Longer
A new service from PGX offers security patches and bug fixes for old, unsupported versions of PostgreSQL. This helps companies that can't upgrade stay secure and maintain data integrity without a costly migration.
Taranpreet Singh ·
Data
Get Smarter Postgres Code Editing in Any Editor
A new open-source tool called postgres-lsp is now available for PostgreSQL developers. It provides advanced code editing features like error checking and auto-completion in any modern code editor, improving productivity and code quality.
Taranpreet Singh ·
Data
Test PostgreSQL Indexes Without Actually Building Them
HypoPG, a popular PostgreSQL extension for testing "hypothetical" indexes without the cost of building them, has a new update. Version 1.4.3 fixes a long-standing bug and adds early support for the upcoming PostgreSQL 19.
Taranpreet Singh ·
Data
New Tool Makes PostgreSQL Code Easier to Compare
A code formatter for PostgreSQL, pgfmt, can now format code to match the standard pg_dump tool. This makes it much easier for developers to track and compare changes in database schemas.
Taranpreet Singh ·
Data
A Key PostgreSQL Performance Tool Gets an Update
The PostgreSQL Workload Analyzer (PoWA) project has released version 5.1.2 of its core tool, powa-archivist. This update provides incremental improvements for developers and IT teams who use it to monitor database performance.
Taranpreet Singh ·
Data
PostgreSQL Anonymizer Now Offers Stronger Data Privacy
The new version of PostgreSQL Anonymizer introduces Local Differential Privacy, a sophisticated technique for data masking. This gives developers a more robust way to protect sensitive user information without compromising data utility.
Taranpreet Singh ·
Security
Ubuntu Patches Key PostgreSQL Flaws
Ubuntu has issued a security notice for two PostgreSQL vulnerabilities. The first flaw could allow an attacker to execute arbitrary SQL functions due to an authorization issue. The second could lead to a server crash or denial of service from mishandled large user inputs. Updates are available.
Neeraj Dhiman ·
Security
Appsmith Flaw Allows Code Injection
A stored cross-site scripting (XSS) vulnerability has been found in Appsmith's SQL query editor. Attackers with developer access to a shared PostgreSQL database can inject malicious code by creating specially named database objects. This code executes when the autocomplete feature is used by other users.
Neeraj Dhiman ·
Data
Microsoft Wants to Run Workflows Inside PostgreSQL
Microsoft has open-sourced a new tool for PostgreSQL called pg_durable. It allows developers to run complex workflows directly inside the database, which can simplify system design by removing the need for external orchestration tools.
Taranpreet Singh ·
Data
Pgpool-II Releases Key Updates for PostgreSQL Stability
Pgpool-II has released maintenance updates across five active versions. The updates provide important bug fixes for teams using the tool to manage high-availability PostgreSQL clusters, ensuring better stability and reliability for database operations.
Taranpreet Singh ·
Infra
AWS Now Lets You Use DynamoDB On PostgreSQL
AWS has released ExtendDB, an open-source tool that lets developers use the popular DynamoDB API with other databases, starting with PostgreSQL. This offers more flexibility and helps avoid being locked into a single cloud vendor.
Ashish Kale ·
Data
First Beta for PostgreSQL 19 Released
The first beta for PostgreSQL 19 is now available for download and testing. This early release provides a preview of new features and improvements coming in the next major version of the popular open-source database. It allows developers and IT teams to begin evaluating the update.
Taranpreet Singh ·
Data
Autobase PostgreSQL Platform Launches Enterprise Edition
Autobase, an open-source PostgreSQL platform, has released version 2.8, introducing a new commercial Enterprise Edition. The existing free version is now the Community Edition. This move provides a new option for businesses seeking managed database solutions as an alternative to traditional cloud-based Database-as-a-Service (DBaaS) offerings.
Taranpreet Singh ·
Data
ClickHouse Unveils Major Product Updates
ClickHouse announced several major updates at its Open House 2026 event. Key developments include deeper integration with Postgres, new data ingestion tools called ClickPipes and ClickHouse Agents, and a partnership with Langfuse for LLM observability. The updates aim to simplify real-time data analytics.
Taranpreet Singh ·