Search Results: PostgreSQL

Snowflake has launched the public preview of its PostgreSQL External Tables feature, enabling users to query PostgreSQL databases directly within Snowflake without complex ETL. This native integration leverages pushdown optimization for efficient execution and signals a strategic embrace of open source ecosystems. The move simplifies hybrid architectures and challenges traditional data integration approaches.

CloudNativePG introduces a groundbreaking approach to managing PostgreSQL extensions, decoupling them from core binaries using Kubernetes ImageVolume. This new method enables dynamic addition, easier evaluation, and simplified updates without building custom container images.

A developer shares the harrowing story of how 89 missing indexes on foreign keys caused catastrophic performance issues in their multi-tenant SaaS application, and the 4-minute fix that saved their launch.

Postgres.app bundles a curated set of PostgreSQL extensions and offers a streamlined path for adding more, all without the usual macOS build headaches. Developers can enable built‑in extensions with a single SQL command, or download and compile custom ones into a dedicated Application Support directory that survives updates. The result is a developer‑friendly workflow that keeps extensions up‑to‑date and secure.

As database complexity grows, AI-powered solutions are emerging to automate the intricate task of PostgreSQL optimization, promising to reduce manual tuning efforts and improve performance for DevOps teams worldwide.

Upgrading a high-throughput PostgreSQL cluster from version 13 to 16 while minimizing downtime is no small feat, especially under 20,000 transactions per second. This article details a strategic approach using physical and logical replication to ensure data integrity and high availability. It highlights the challenges overcome and the benefits of PostgreSQL 16's enhancements for modern workloads.