PostgreSQL Archives

Tech Optimizer

September 1, 2026

Connecting My LangGraph AI Agent to Postgres

A stateful LangGraph agent was developed to streamline a 15-minute booking process, featuring a user-friendly Streamlit UI and a backend powered by a Postgres database. The agent responds to customer queries, calculates service pricing, manages service acceptance, suggests time slots, and confirms appointment details. It operates in two modes: in-memory for rapid testing and Postgres for persistent storage. Testing can be done locally using Docker, which simulates a Postgres environment, or with a hosted Postgres instance. The project includes a docker-compose.yml file to initiate a PostgreSQL 16 container, allowing the application to connect to the database. Data persistence is ensured through Docker volumes, and the application can be run with specific commands after setting up the environment variables. The system has been tested successfully, demonstrating its ability to manage bookings and maintain data integrity across sessions. Future enhancements are planned to improve the booking workflow and integrate additional communication channels.

Tech Optimizer

September 1, 2026

Autoscaling Lakebase Postgres

Choosing a database instance size without prior knowledge of the workload can lead to inefficiencies and excessive compute usage. Lakebase Postgres addresses this with an autoscaling feature that eliminates manual sizing, utilizing in-place VM resizing and a monitoring algorithm for CPU, memory, and working set size. Lakebase Postgres separates compute and storage layers, allowing independent resizing of compute nodes without affecting the database. The autoscaling algorithm relies on three signals: CPU load (cpuGoalCU), memory use (memGoalCU), and compute-cache working set size (lfcGoalCU). The CPU load is monitored every five seconds, aiming to maintain it at or below 90% capacity. Memory usage is tracked at two frequencies: overall memory every five seconds and Postgres-specific memory every 100 milliseconds, with a goal to keep usage below 75% of allocated RAM. The compute cache evaluates active data access efficiency, adjusting size based on workload. The working set is estimated using a modified HyperLogLog algorithm that records timestamps for page accesses, allowing for distinct page estimates over various time frames. The algorithm projects future working-set growth to allocate sufficient cache while capping it at 75% of RAM. Resizing the compute involves four components: the autoscaler-agent, vm-monitor, Kubernetes scheduler, and NeonVM. Scaling up occurs when any of the three goals indicate a need for more resources, while scaling down includes verification to ensure sufficient memory remains for operations. Timely adjustments in both directions are prioritized to minimize costs.

Tech Optimizer

August 29, 2026

Overcoming the Barriers of Commercial DBs with Open Source and AI… EDB Hosts ‘PostgreSQL AI Summit’

A company's approach to artificial intelligence (AI) begins with determining the optimal structure for data storage and management, often facing challenges such as high costs of commercial databases and reliance on specific enterprise technologies. To effectively utilize AI, companies need to establish new infrastructures, including vector search capabilities, Search Augmentation Generative (RAG) systems, and data lakehouses. EDB is notable for connecting companies and technology partners that have transitioned to open-source databases. On September 3, EDB will host the 'EDB Postgres AI Summit Seoul 2026' at the Sofitel Ambassador Seoul, starting at 10:00 AM. This event is the largest PostgreSQL conference in Korea, themed 'Change the Game,' focusing on the shift from commercial databases to open-source and AI-driven frameworks, featuring real-world case studies. Approximately 300 C-level executives and IT decision-makers from various sectors are expected to attend, with participation by invitation only. The summit will include 15 sessions with customer case studies and technical presentations. Notable discussions will include IBK Industrial Bank of Korea's migration of 15 core systems to PostgreSQL, a semiconductor company's diversification of MPP databases on a DBaaS platform, and Kyobo Book Centre's database modernization strategy. Shopcast will present its development of an 'Agentic Lakehouse' integrating AI technology with a data lakehouse framework. The keynote address will be given by Kim Deok-joong, discussing organizational management strategies for integrating AI agents. The technical sessions will cover the architecture of the 'EDB Postgres AI' platform, which supports AI vector search and RAG, with live demonstrations of the analytics engine ClickHouse and LakeHouse technology for analyzing petabyte-scale data. EDB's domestic distributors and international partners will participate as sponsors. The summit aims to showcase technologies and case studies from the domestic ecosystem, addressing PostgreSQL adoption, system migration, operations, data analysis, and AI implementation. EDB manages transaction, analytics, and AI workloads using Postgres in cloud environments, serving over 1,500 global customers. Herve Timsit, EDB's Chief Revenue Officer, emphasized the event's focus on sharing tangible results and addressing the challenges of commercial databases while investing in AI infrastructure.

Tech Optimizer

August 29, 2026

Databricks Unveils Lakebase Postgres

Lakebase Postgres features a two-layer architecture that separates operations for durability and scalability. The compute layer uses standard Postgres for SQL parsing, query planning, and execution, designed to be ephemeral for dynamic scaling. The storage layer ensures correctness, durability, and historical accuracy, consisting of three components: Safekeepers replicate Write-Ahead Logging (WAL) records using a quorum-based protocol; Pageserver transforms WAL records into page versions; and Object Storage retains materialized versions and historical states in an immutable format. This architecture enhances data durability and system scalability.

Tech Optimizer

August 25, 2026

EDB Brings Postgres-Proven Disaster Recovery to Petabyte-Scale WarehousePG Where Downtime Is Not Possible

On August 20, 2026, EnterpriseDB (EDB) announced the general availability of its Disaster Recovery feature for WarehousePG, enhancing EDB Postgres AI's analytical capabilities by enabling recovery of petabyte-scale data in minutes rather than days. This feature allows organizations to maintain a current recovery environment across on-premises, cloud, or hybrid setups, and provides flexibility in activating recovery. The implementation of Disaster Recovery for WarehousePG resulted in approximately 180 times faster recovery, with restore-point replay averaging 16 minutes, full backups decreasing from 44 hours to about 11 hours, and nearly 99% less query lock time. The recovery model was achieved without any modifications to the application architecture. WarehousePG leverages the Postgres framework for disaster recovery processes and includes built-in high availability to safeguard against component failures. The upcoming September version update will integrate Disaster Recovery configuration into WarehousePG Enterprise Manager, allowing operational teams to manage cluster health and resource utilization effectively.

Tech Optimizer

August 25, 2026

Hands-On with Snowflake Postgres: Build Apps and AI without the ETL

Developers face challenges in maintaining fragile data pipelines that connect transactional data to analytical insights. Snowflake Postgres provides a solution that allows developers to focus on innovation. A Virtual Hands-On Lab will demonstrate the capabilities of Snowflake Postgres, requiring participants to have a Snowflake free trial. Key features include rapid deployment of a fully-managed Postgres foundation, elimination of data pipelines through the pg_lake extension, integration with Snowflake Cortex AI for real-time data reasoning, and built-in high availability with a 99.95% uptime SLA. The event is aimed at Software Developers, AI/ML Engineers, and Data Engineers who want to use their Postgres tools on the Snowflake platform.

Tech Optimizer

August 25, 2026

Migrate Vaultwarden to PostgreSQL: Scale for Teams [2026]

Self-hosting Vaultwarden with SQLite can lead to performance issues as the user base grows, particularly due to SQLite's limitations with concurrent writes. Transitioning to PostgreSQL allows for better performance, multi-user support, and enhanced data durability. PostgreSQL supports concurrent connections and row-level locking, making it more suitable for team environments. To migrate from SQLite to PostgreSQL, certain prerequisites must be met, including having an existing Vaultwarden deployment, Docker Engine, a PostgreSQL server, and pgloader installed. The migration process involves backing up existing data, deploying a PostgreSQL container, updating configuration files, and using pgloader to transfer data. A VPS with 2 vCPU and 4GB RAM can support up to 50 users, with larger teams requiring more resources. PostgreSQL also allows for the creation of organizations for shared vault access and the configuration of group policies for security. Regular backups and performance tuning are necessary to maintain optimal operation. Common pitfalls during migration include not stopping the Vaultwarden container before migration, failing to encode special characters in the database password, and neglecting to back up data. Troubleshooting may involve checking connection strings and ensuring the PostgreSQL container is healthy. Advanced configurations can enhance performance and functionality, and understanding the differences between Vaultwarden and Bitwarden's official self-hosted server can aid in decision-making.

Tech Optimizer

August 19, 2026

Electric Joins Databricks to Bring WASM Postgres to AI Agent Sandboxes, Expanding Databricks Postgres from the Lakehouse to the Edge

Databricks has integrated the Electric team to enhance its capabilities by incorporating WASM Postgres into AI agent sandboxes. Electric has developed PGlite, which provides each agent with a lightweight Postgres instance for low-latency access to local context, facilitating real-time data processing. Their real-time sync engine maintains synchronization of agents' distributed states with a central Lakebase, allowing effective collaboration among agents. Both Electric and Lakebase utilize Postgres, with Lakebase offering it at a production scale and PGlite introducing WASM Postgres into the agent's environment. This integration allows for collaborative applications, execution of Postgres within the agent sandbox, and ensures synchronization among agents while centralizing control in Lakebase Postgres.

Tech Optimizer

August 19, 2026

Postgres pioneer credits Oracle with helping his database take over the world

Michael Stonebraker, the creator of PostgreSQL, noted that Oracle's acquisition of MySQL inadvertently boosted PostgreSQL's prominence among major tech companies like Microsoft, AWS, and Google. PostgreSQL, which originated from Stonebraker's earlier Postgres system proposed in 1986, celebrated its 30th anniversary this summer. Its popularity surged over the past five years, becoming the preferred database among developers in 2023, as per a Stack Overflow survey. Microsoft has launched a distributed PostgreSQL database service to compete with other offerings. Stonebraker highlighted the extensive adoption of PostgreSQL's wire format by major companies, contrasting it with MySQL's declining competitiveness since Oracle's acquisition in 2010. He expressed gratitude towards Oracle for prompting users to consider PostgreSQL as an alternative, emphasizing its open-source nature and community-driven control. Stonebraker has founded several database companies and co-founded DBOS three years ago, which has pivoted towards AI agents and partnerships with Databricks and CockroachDB.

Tech Optimizer

August 18, 2026

Oh no, not another one! Databricks buys Electric

Databricks has acquired Electric, the developer of PGLite and the Electric Sync Engine, to enhance its Postgres capabilities for lakehouse and edge environments. PGLite offers lightweight Postgres instances for low-latency access, while the Electric Sync Engine enables real-time synchronization of distributed state to a central Lakebase. Electric was founded in September 2021 and has raised funding from various investors. Its flagship product, PGLite, has seen a rise in weekly downloads from 1 million to 13 million. Electric also offers open-source products including Electric Agents, Electric Streams, and Electric Sync. Databricks previously acquired Neon in May 2022 to support serverless Postgres solutions. The integration of Electric's technology aims to enhance collaboration and scalability for agentic applications.