Database
PostgreSQL at scale
Operating PostgreSQL when the dataset and write rate stop fitting on a single instance — partitioning, replication, vacuum tuning, and the managed-service landscape.
PostgreSQL is now the default database for most new applications; the operational complexity of running it at scale used to be a major drawback, but the managed-service ecosystem (Aurora, AlloyDB, Neon, Supabase, RDS) and the extension ecosystem (Citus, TimescaleDB, pgvector) have closed most of that gap.
Notifire's coverage tracks the releases and tooling that change the cost-or-complexity curve: logical replication maturity, partition routing, vacuum behaviour under high write load, and the connection-pooling layer (PgBouncer, pgcat) that sits in front of nearly every production deployment.
Latest briefings on PostgreSQL at scale
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 ·
Security
Critical Drupal Flaw Affects PostgreSQL Sites
Drupal has issued security updates for a highly critical vulnerability in its Core software, tracked as CVE-2026-9082. The flaw affects sites using a PostgreSQL database and could allow attackers to execute remote code, escalate privileges, or access sensitive information. Immediate patching is strongly recommended.
Neeraj Dhiman ·
Data
New Postgres extension improves data handling
A new version of pg_sorted_heap, a PostgreSQL extension, has been released. It introduces physically sorted storage and integrated vector search. Version 0.14.0 adds official support for PostgreSQL 16 and is now available on the PostgreSQL Extension Network (PGXN) for easier installation and management.
Taranpreet Singh ·
Data
ChatFeatured boosts AI analytics performance
AI brand discovery platform ChatFeatured migrated its analytics database from PlanetScale Postgres to a Postgres-compatible service managed by ClickHouse. The switch, completed in 30 minutes, reduced complex query times from 2.5 minutes to under one second, significantly improving performance for its AI-powered features.
Taranpreet Singh ·
Frequently asked questions
When does a PostgreSQL deployment outgrow a single instance?
Three classic triggers: write throughput exceeding the largest instance's WAL bandwidth (~tens of thousands of writes/sec), table sizes where index maintenance vacuum runs longer than the autovacuum interval, or a working set that no longer fits in RAM. Each has a different mitigation — sharding, partitioning, or read replicas.
Is Postgres logical replication production-ready?
Yes, but with caveats. Logical replication is solid for read replicas, zero-downtime major-version upgrades, and CDC pipelines. It still struggles with large transactions, DDL replication, and conflict resolution in multi-writer setups. PG 16+ closed many of these gaps; PG 17 closed more.
Should you use pgvector or a dedicated vector database?
If your application already runs on Postgres and your vector workload is moderate (≲100M vectors, ≲100 QPS), pgvector with the HNSW index is the right answer — same backup, same transactions, same operations team. Above that scale, a purpose-built vector DB starts to pay off.