Extension

Tech Optimizer
May 28, 2026
Postgres engines can now connect to large data repositories using extensions like pg_lake, allowing access to files in object storage formats such as CSV, JSON, Apache Parquet™, and Apache Iceberg™. The Apache AGE™ extension enhances data usability through graph relationships, enabling complex queries that require both graph traversal and analytical aggregation. Apache AGE introduces openCypher graph query support within Postgres, allowing for integration without data movement, as both Iceberg tables and graphs reside in the same database. This integration facilitates the construction of graphs from lake tables, allows for combining SQL and Cypher queries, and simplifies operational processes by consolidating application connection, security, and backups into a single workflow. An example of this integration is a healthcare platform using Iceberg tables on Amazon S3, which includes various data types such as claims, providers, patients, and referrals. To utilize these features, necessary Postgres extensions must be loaded, with pg_lake operating alongside a sidecar, the pgduck_server, for Iceberg operations.
AppWizard
May 20, 2026
Herman Miller has launched the Coyl gaming desk, marking its entry into the gaming desk market. The desk features a distinctive coiled red power cable that powers its electronic sit-stand adjustable-height legs and an integrated multi-socket extension cord. It includes a cable tray with a flip-down fabric cover for easy access, a pegboard/accessory mount section for various holders, and a dedicated headset hook. The height control system uses a large knurled knob instead of conventional buttons. The desk is available in multiple finishes and comes with a 12-year warranty. The starting price is ,475, and it is currently available for purchase in North America.
Tech Optimizer
May 20, 2026
A coalition of companies, including AWS, Percona, Supabase, pgEdge, and Tiger Data, has formed to support the maintenance of pgBackRest, an extension for the PostgreSQL database, after its long-time maintainer, David Steele, could no longer continue due to a lack of sponsorship following the acquisition of Crunchy Data by Snowflake. pgBackRest is a backup and restore solution for PostgreSQL, which is widely used by major cloud service providers. Steele had been seeking sponsorship to maintain the project but was unsuccessful, prompting concerns about its future. The coalition aims to provide stability and reduce reliance on a single sponsor by onboarding a new maintainer and seeking additional support. Percona's CEO emphasized the importance of collaboration to ensure the project's health for the community.
Tech Optimizer
May 19, 2026
A public proof-of-concept exploit has been released for CVE-2026-2005, a critical heap-based buffer overflow vulnerability in PostgreSQL's pgcrypto extension, allowing full remote code execution and privilege escalation to the database superuser level. This vulnerability has existed since 2005 and was discovered by an AI-powered security tool during the ZeroDay.Cloud 2025 event in December 2025. An upstream patch was committed on February 8, 2026, and released on February 12, 2026. The vulnerability has a CVSS score of 8.8 and affects approximately 80% of cloud environments using PostgreSQL, with 45% accessible via the internet. The flaw is in the pgp_parse_pubenc_sesskey() function, which lacks bounds checking, allowing attackers to manipulate session key lengths. The pgcrypto extension can be installed by any database role with CREATE privileges, increasing the risk of exploitation. The proof-of-concept exploit involves an information leak, arbitrary write, and privilege escalation to remote code execution. The vulnerability affects all major versions of PostgreSQL prior to the February 2026 releases, which include versions 18.2, 17.8, 16.12, 15.16, and 14.21. Mitigation steps include upgrading to patched versions, restricting CREATE privileges, blocking direct internet exposure, rotating database credentials, auditing the usage of COPY FROM PROGRAM, and verifying patched engine versions for cloud-managed PostgreSQL users.
Tech Optimizer
May 15, 2026
PostgreSQL is widely used across various industries, supported by Microsoft through significant investments, including 345 commits to the latest release and a dedicated team of contributors. It is recognized for its ability to handle complex production challenges, such as transactional integrity and concurrency management. Microsoft operates PostgreSQL globally, informing upstream contributions based on real-world deployment experiences. The database is increasingly integrated into AI applications, with Azure Database for PostgreSQL and Azure HorizonDB focusing on AI functionalities. Microsoft offers multiple deployment models to accommodate different workload needs, including Azure Database for PostgreSQL for open-source workloads and Azure HorizonDB for cloud-native systems. Recent contributions from Microsoft include enhancements in asynchronous I/O, vacuum behavior, and query planning. Azure HorizonDB is designed for high-throughput, low-latency systems requiring horizontal scaling. Microsoft also invests in developer tools, such as a Visual Studio Code extension for PostgreSQL, and sponsors PostgreSQL conferences and user groups globally.
Search