Postgres Archives

Tech Optimizer

March 26, 2026

EDB Highlights CloudNativePG 1.29, Previews Kubernetes-Native Data Protection at KubeCon Europe

EnterpriseDB (EDB) has released CloudNativePG 1.29, an open-source PostgreSQL operator for Kubernetes, featuring modular extensions and enhanced supply chain security. This version allows users to install only necessary PostgreSQL extensions, including options for AI-driven vector search, while ensuring the use of verified components. EDB is also previewing a new enterprise data protection solution for its EDB Postgres AI for CloudNativePG operator, which includes zero data loss through write-ahead log streaming, centralized management, disaster recovery support, and end-to-end encryption. EDB emphasizes its commitment to data and AI sovereignty and security compliance in Europe, adhering to regulations like the EU Cyber Resilience Act, and aims to support PostgreSQL operations across on-premises and cloud environments to avoid vendor lock-in.

Tech Optimizer

March 26, 2026

EDB Highlights Community Release of CloudNativePG 1.29 and Previews Exclusive Kubernetes Data Protection at KubeCon Europe

EnterpriseDB (EDB) has released CloudNativePG 1.29, an open-source Postgres operator for Kubernetes, and introduced an enterprise-grade data protection solution for its commercial CNPG operator. Open-source strategies are crucial for 80% of major enterprises in the EMEA region, with only 13% achieving success in AI and data initiatives through sovereign data platforms. The EU Cyber Resilience Act mandates secure software supply chain practices. CloudNativePG has gained over 8,000 stars on GitHub and now features modular extensions and built-in supply chain security. EDB is developing a Kubernetes-native data protection solution offering Zero Data Loss and centralized management. This solution supports compliance with the EU Cyber Resilience Act and ensures operational control while reducing cloud infrastructure costs. EDB Postgres® AI is positioned as a secure, compliant, and scalable sovereign data and AI platform.

Tech Optimizer

March 26, 2026

Announcing Amazon Aurora PostgreSQL serverless database creation in seconds

Colin Lazier, Vice President of Databases at AWS, announced at re:Invent 2025 that developers can now create production-ready databases using Amazon DynamoDB and Amazon Aurora DSQL in seconds. AWS introduced an express configuration for Amazon Aurora PostgreSQL, allowing users to set up a serverless database in two clicks without needing an Amazon VPC network. This configuration includes preconfigured defaults, IAM authentication for passwordless access, and an internet access gateway for secure connections. Users can create an Aurora PostgreSQL serverless database via the AWS console or command-line interface, and they can customize settings during and after creation. The new setup supports additional features like read replicas and automated failover. AWS also enhanced the Free Tier program, providing up to 0 in credits for new users, and integrated Aurora with platforms like Vercel for rapid application development. Users are billed based on Aurora Capacity Units (ACUs), which scale automatically.

Tech Optimizer

March 19, 2026

Building a High-Performance Postgres Time Series Stack with Iceberg

Postgres extensions, specifically pg_lake, pg_partman, and pg_incremental, provide a vendor-agnostic, open-source solution for managing high-performance time series data. PostgreSQL serves as the foundation, while pg_partman automates time partition management, pg_lake connects Postgres with data lakes for offloading cold data, and pg_incremental processes append-only data in batches. These extensions are maintained by the Postgres team at Snowflake. An example system for monitoring temperature readings uses local storage for recent data and transitions cold data to an Apache Iceberg table on S3. The process includes creating a partitioned table in Postgres, establishing an Iceberg table, using pg_incremental for data appending, eliminating old partitions with pg_partman, and querying from both local and cold tables to optimize storage and costs. A time-partitioned table enhances performance by allowing efficient deletion of outdated data, speeding up queries, and reducing fragmentation.

Tech Optimizer

March 17, 2026

EDB Accelerates Postgres for the Agentic Workforce Era with NVIDIA AI Infrastructure and Interactive Analytics

EnterpriseDB (EDB) has advanced its integration with NVIDIA's cuDF for Apache Spark to enhance Postgres® performance on NVIDIA AI infrastructure, achieving analytics capabilities up to 100 times faster than traditional methods. EDB emphasizes the need for a real-time analytics framework to address challenges posed by fragmented data silos and inefficient analytics processes. Key features of EDB Postgres AI include GPU-acceleration for interactive analytics, NVIDIA NIM model serving, fully air-gapped support for private registries, and high-speed retrieval with NVIDIA NeMo Retriever. Research indicates only 13% of enterprises have transitioned to production-scale agentic deployments, which report five times higher ROI. The EDB PG AI Analytics Engine can achieve 50–100x faster analytics on large datasets, supports lakehouse architectures, and ensures workload isolation and governance. EDB PG AI is positioned as a secure, compliant, and scalable platform for operationalizing data and AI workloads.

Tech Optimizer

March 13, 2026

EDB tops new ranking of commercial Postgres backers

EnterpriseDB (EDB) has launched the Postgres Vitality Index, which ranks commercial contributors to PostgreSQL, highlighting EDB's claim of over 30% of contributions. The index evaluates contributions based on core code, ecosystem extensions, and community support. EDB is positioned ahead of AWS and Microsoft in contributions. EDB's product strategy includes EDB Postgres AI, addressing data sovereignty and governance for AI systems, emphasizing a hybrid architecture for various workloads. EDB aims to enhance Postgres's readiness for enterprise AI, while also publishing resources related to Postgres and AI architecture. The index's introduction aligns with an increase in managed Postgres offerings and tools from various vendors.

Tech Optimizer

March 12, 2026

Why Postgres® has won as the de facto database: Today and for the agentic future

The AI economy is projected to reach a trillion by 2028, leading 95% of major global enterprises to establish AI and data platforms within two years, although only 13% have succeeded so far. Successful integration of agentic AI requires moving away from outdated architectures to a cohesive data and AI approach. Currently, 81% of successful enterprises utilize open-source strategies, with over 40% standardizing on PostgreSQL. PostgreSQL's extensibility allows for the integration of diverse data types, essential for AI applications. It provides a unified database engine that mitigates issues associated with fragmented architectures. PostgreSQL benefits from a large independent developer community, which enhances its innovation and adaptability. To thrive in the future, organizations must abandon legacy systems and leverage PostgreSQL's capabilities for a sovereign data platform.

Tech Optimizer

March 12, 2026

The Postgres® Vitality Index: Enterprises Rush to Postgres, and EDB Continues to Lead the Foundation for Sovereign Enterprise AI

EnterpriseDB (EDB) has launched the Postgres Vitality Index to evaluate the commercial contributions shaping PostgreSQL's future. The index indicates that Postgres is the most strategically invested-in database globally, with EDB as the leading contributor, accounting for over 30% of contributions. Postgres is favored by over 55% of developers, reflecting its growing adoption among major tech firms. The index assesses contributions in three areas: core advancements in the PostgreSQL codebase, ecosystem enhancements through extensions and tools, and community support. EDB's Postgres AI platform addresses the need for data and AI sovereignty, offering a hybrid architecture for governance and flexibility. EDB has also published a guide on building AI platforms with Postgres, which will be distributed at NVIDIA's GTC event.

Tech Optimizer

March 11, 2026

Moving AI apps from prototype to production requires enterprise-grade postgres infrastructure

By 2024, 78% of organizations are expected to utilize AI, a significant increase from previous years. However, 90% of technology leaders struggle to measure the return on investment from AI initiatives. Traditional databases are inadequate for AI applications due to limitations in features like vector similarity search and semantic retrieval. Many organizations face challenges in integrating AI applications with existing databases, particularly when migrating legacy systems to the cloud. Security and compliance are critical for AI applications in regulated industries, requiring audit trails, data encryption, and adherence to standards like HIPAA and GDPR. The absence of dedicated vendors for transitioning AI from prototyping to production is notable, with no Postgres vendor focusing solely on AI integration until recently. Anthropic's open-source Model Context Protocol (MCP) has emerged as a standard for connecting AI agents to data sources, easing integration challenges. The underlying database architecture is crucial for supporting enterprise-grade AI applications, with Postgres being a common choice. The pgEdge Agentic AI Toolkit for Postgres provides a solution for building production-ready AI applications while ensuring availability, security, and compliance.

Tech Optimizer

March 11, 2026

Netflix Automates RDS PostgreSQL to Aurora PostgreSQL Migration Across 400 Production Clusters

Netflix has developed an internal automation platform to migrate Amazon RDS for PostgreSQL databases to Amazon Aurora PostgreSQL, reducing operational risks and downtime for nearly 400 production clusters. The platform allows service teams to perform migrations through a self-service workflow while ensuring processes like replication validation and rollback safeguards are maintained. Database access is managed through a platform-managed layer using Envoy, which standardizes mutual TLS and abstracts database endpoints, enhancing security and efficiency. The migration process starts with creating an Aurora PostgreSQL cluster as a read replica of the source RDS instance, initialized from a storage snapshot and continuously replaying write-ahead log (WAL) records. Validation checks are performed to ensure the replica can handle peak write throughput before cutover. For change data capture workloads, the system coordinates the state of replication slots and pauses CDC consumers to prevent excessive WAL retention. The Enablement Applications team at Netflix successfully migrated databases for device certification and partner billing workflows, addressing issues like elevated replication lag due to inactive logical replication slots. As replication lag decreases, the system enters a controlled quiescence phase, adjusts security rules, and reboots the source RDS instance. Once all transactions are processed and the Aurora replica is ready, it is promoted to a writable cluster, and traffic is rerouted. Rollback capabilities are prioritized, allowing redirection back to the original RDS instance if validation checks fail or anomalies are detected post-promotion. This setup enables seamless restoration without redeployment, and CDC consumers can resume from recorded slot positions if needed.