Pstgre Archives

Tech Optimizer

June 17, 2026

Databricks Puts AI Search Inside Postgres

Databricks has introduced Lakebase Search, a feature that integrates advanced search capabilities into its Lakebase Postgres database, currently in beta on AWS and Azure. This feature aims to enhance AI agent development by embedding native retrieval functions within the data backend. It addresses the challenge of "Vector Bloat Cost" by utilizing tiered storage for optimized data access and retrieval efficiency. Lakebase Search includes two new Postgres extensions, lakebase_vector and lakebase_text, which enable hybrid search capabilities that combine vector and full-text search functionalities. This integration streamlines the AI agent loop, improving agent-first ergonomics and allowing developers to create more efficient AI systems.

Tech Optimizer

June 17, 2026

Snowflake Simplifies Postgres Data Sync

Snowflake has introduced features to improve data integration between PostgreSQL and its platform, addressing challenges in transferring data between online transaction processing (OLTP) and online analytical processing (OLAP). One key feature is data mirroring, which offers low-latency replication for PostgreSQL, automatically maintaining target tables to reflect source changes with minimal setup effort. These advancements aim to simplify data integration, reduce costs associated with ETL tools, and facilitate real-time insights, enhancing operational efficiency for organizations.

Tech Optimizer

June 14, 2026

Automate Amazon Aurora PostgreSQL major or minor version upgrade using AWS Systems Manager and Amazon EC2

Managing upgrades for the Aurora PostgreSQL-Compatible Edition can be labor-intensive and error-prone when done manually. Automating Amazon Aurora PostgreSQL upgrades can reduce manual effort by up to 80% and minimize downtime risks through consistent procedures. The automation solution uses AWS Systems Manager, Amazon EC2, and AWS Secrets Manager, structured around two modules: PREUPGRADE for readiness checks and UPGRADE for the actual upgrade process. The solution identifies upgrade candidates using database tags, creates safety backups with Copy-on-Write clones, manages the upgrade process with minimal human intervention, and offers real-time monitoring and email notifications. The workflow includes logging into the Systems Manager console, downloading the upgrade script, identifying Aurora PostgreSQL clusters based on tags, retrieving credentials from AWS Secrets Manager, executing pre-upgrade checks or upgrades, uploading log files to Amazon S3, and sending email notifications via Amazon SNS. Prerequisites include familiarity with the Aurora upgrade process, appropriate IAM permissions, creating a maintenance user, setting up AWS Secrets Manager, tagging Aurora clusters, creating an S3 bucket, and configuring an SNS topic for notifications. Implementation steps involve reviewing setup instructions, uploading the upgrade script to S3, creating an AWS Systems Manager automation document, executing the automation document, and monitoring the upgrade process through logs generated during pre-upgrade and upgrade phases. The logs provide detailed information on tasks performed, including replication slot status and configuration backups. After testing, it is recommended to clean up resources to avoid future charges.

Tech Optimizer

June 14, 2026

Neon vs Supabase 2026: $1B Deal, Scale-to-Zero

Neon and Supabase are two managed PostgreSQL platforms with distinct approaches. Neon adopts a serverless architecture that separates storage and compute, allowing databases to scale to zero when idle and enabling rapid database branching. Supabase, in contrast, provides a comprehensive backend-as-a-service that includes authentication, file storage, real-time subscriptions, and edge functions, all built around PostgreSQL. In 2025, Databricks acquired Neon for approximately billion, motivated by the observation that around 80% of databases created on Neon were generated by AI agents. Post-acquisition, users experienced reduced storage costs and improved pricing structures, although concerns arose regarding Neon's independence. Neon features instant database branching and a scale-to-zero capability, while Supabase offers a fully integrated backend with built-in authentication and storage. Neon operates on a usage-based pricing model, whereas Supabase has a flat-tier pricing structure. Both platforms support the pgvector extension for AI applications, but Supabase is fully open-source and allows for self-hosting, unlike Neon. The developer community recognizes Supabase for its ease of use and rapid application development capabilities, while Neon is praised for its innovative serverless features and cost efficiency. Migration between the two platforms is simplified due to their shared PostgreSQL foundation.

Tech Optimizer

June 13, 2026

Why Use App-Level Auth When Every Database Has Auth? (Splunk Enterprise CVE-2026-20253 Pre-Auth RCE)

On June 10th, Splunk released an advisory for CVE-2026-20253, a high-severity vulnerability with a CVSS score of 9.8 that requires no authentication. The vulnerability is associated with the PostgreSQL Sidecar Service Endpoint and affects Splunk Enterprise versions 10 and above. In default installations, the service is not installed on Windows but is installed and enabled by default on AWS. The vulnerability allows unauthorized users to create and truncate arbitrary files through an API that lacks authentication controls. Additionally, it enables the execution of SQL commands via a backup and restore mechanism, potentially leading to remote code execution (RCE). A Detection Artefact Generator has been developed to help organizations assess their vulnerability to this issue.

Tech Optimizer

June 11, 2026

As the Agentic Era Reshapes the Data Layer, Enterprises Build Their Sovereign Foundation on EDB Postgres® AI

EnterpriseDB (EDB) has reported a significant increase in global adoption of its EDB Postgres® AI (EDB PG AI) platform, indicating a trend among enterprises to standardize operations on a robust platform for managing mission-critical workloads. Research by MIT Technology Review Insights, in collaboration with EDB, shows that AI and data sovereignty are critical predictors of success in AI initiatives, with organizations prioritizing control over their data achieving a fivefold return on investment. The Industrial Bank of Korea (IBK) transitioned 15 core systems to EDB PG AI for greater operational flexibility and cost efficiency, reducing licensing costs compared to Oracle. Shinhan EZ Insurance migrated its entire core system to the public cloud to ensure uninterrupted service. Other enterprises leveraging EDB PG AI include MNTN, Euronext FX, and Kyobo Book Centre, which have benefited from enhanced stability, reduced vendor risk, and improved compliance. EDB is recognized as a leader in the field and will host a global digital event titled "The Era of Agentic AI Data" on June 25. EDB Postgres® AI is positioned as an open, enterprise-grade sovereign data and AI platform, supporting secure, compliant, and scalable solutions across various environments.

Tech Optimizer

June 10, 2026

Microsoft Open-Sources PostgreSQL Extension for In-Database Durable Execution

Microsoft has introduced pg_durable, a PostgreSQL extension that enables developers to execute durable workflows within the database, reducing the need for external orchestration systems. It simplifies workflow management by allowing developers to express long-running, fault-tolerant SQL functions directly in SQL, managing execution concerns like retries and recovery. Workflows are defined in SQL, with the extension handling retry states, progress tracking, and checkpointing. A pg_durable function operates as a graph of SQL steps that can resume from the last durable checkpoint after a failure. The extension preserves execution states within PostgreSQL tables, ensuring workflows can withstand crashes and restarts. It includes a domain-specific language (DSL) for scheduling and parallel execution. An example of a durable function is provided, demonstrating sequential and parallel execution using specific operators. pg_durable is particularly useful for vector embedding pipelines and scheduled maintenance tasks. Architecturally, it consists of a PostgreSQL extension and a background worker built on Rust libraries, without any external control plane. Durable execution allows long-running workflows to automatically resume from failure points, simplifying distributed system architecture.

Tech Optimizer

June 10, 2026

Tiger Data launches Ghost managed PostgreSQL service for AI agents

Tiger Data has launched Ghost, a managed PostgreSQL service designed for AI agents, providing infrastructure for coding and workflow agents to conduct large-scale experiments. The service features Fluid Storage, which uses a copy-on-write methodology to optimize storage efficiency and reduce costs by charging users only for modified data. Ghost also includes a "fast forking" capability, allowing users to quickly duplicate datasets for experimental environments. It is compatible with major PostgreSQL extensions like TimescaleDB and PostGIS. The pricing model is usage-based, charging users based on actual computing consumption rather than the number of databases created.

Tech Optimizer

June 9, 2026

Tiger Data launches PostgreSQL extension designed for AI agents

Tiger Data has launched a managed PostgreSQL database service called Ghost, designed for AI agents, addressing the limitations of traditional database architectures for autonomous software. The service is now generally available and allows agents to create unlimited databases quickly through a feature called "fast forking." Ghost utilizes Tiger Data's Fluid Storage technology, which employs a copy-on-write storage layer, enabling multiple database instances to share data blocks while charging users only for changed data. The service supports popular PostgreSQL extensions and is positioned as an evolution of PostgreSQL, maintaining its compatibility with the existing ecosystem. Tiger Data has raised 0 million in funding and employs 200 individuals across 25 countries.

Tech Optimizer

June 9, 2026

Tiger Data Launches Ghost, a Purpose-Built Database Service for the Agentic Era

Tiger Data has launched Ghost, a database service designed specifically for AI agents, addressing the limitations of traditional databases in supporting AI-driven workflows. Ghost allows for isolated environments where agents can experiment without affecting shared resources, offering unlimited Postgres databases with rapid forking capabilities. It features a cost-effective per-query pricing model and includes a free tier with 100 compute hours per month and 1TB of storage. Ghost is compatible with various MCP-enabled agent harnesses and is built on Postgres, providing a familiar operational model for teams. Comprehensive documentation and deployment resources are available at tigerdata.com.