EnterpriseDB next month is expected to formally launch a new lakehouse that puts Postgres at the center of analytics workflows, with an eye toward fut

EDB Puts Postgres in the Middle of Analytics Workflow with New Lakehouse Stack

submited by

Style Pass

2024-04-24 21:00:06

EnterpriseDB next month is expected to formally launch a new lakehouse that puts Postgres at the center of analytics workflows, with an eye toward future AI workflows. Currently codenamed Project Beacon, EDB’s new data lakehouse stack will utilize object storage, an open table format, and query accelerators to enable customers to query data through their standard Postgres interface, but in a highly scalable and performant manner.

The popularity of Postgres has skyrocketed in recent years as organizations have widely adopted the open source database for new applications, especially those running in the cloud. The database’s proven scale-up performance, historical stability, and adherence to ANSI standards has allowed it to become, in effect, the default relational database option for running online transaction processing (OLTP) workloads.

While Postgres’ fortunes have soared on the transactional side of the ledger, it hasn’t found nearly as much success when it comes to online analytical processing (OLAP) workloads. Organizations will typically do one of two things when they want to run analytical queries against data they have stored in Postgres: just deal with the meager analytical capabilities of the relational row store, or ETL (extract, transform, and load) the data into a purpose-built relational database that scales out and features columnar storage, which better supports OLAP-style aggregations.