NOW IN PREVIEW
Analytics Accelerator
Unlock rapid analytics in Postgres® with the PGAA extension, providing a vectorized query engine for 30x faster queries over data unified in Postgres, and use tiered tables to offload historical data so critical workloads keep running at full speed.
Key Benefits
Simple and seamless analytics
Eliminate ETL (extract, transform, load) pipelines and data engineering overhead, while reducing storage costs up to 18x using cost-efficient object storage.
Centralized business intelligence
Bring together all business and customer data in Postgres—structured, semi-structured, and unstructured—to power holistic insights for stronger outcomes.
Faster time to insights
Take decisive action from rapid insights across operational and historical data with analytical queries that are 30x faster, on average, compared to standard Postgres.
Zero-compromise platform
Gain confidence that your critical transactional workloads remain unaffected by analytics. Offload cold data to flexible storage locations—boosting system performance and business resilience.
Key Features
Vectorized query engine
Upgrade your standard Postgres query engine with a vectorized query engine that is optimized for columnar data formats, allowing analytical queries to run 30x faster compared to Postgres.
Tiered tables
Query hot data and cold data with a single dedicated node, ensuring optimal performance by automatically offloading cold data to columnar tables in object storage, reducing the complexity of managing analytics over multiple data tiers.
Separated storage and compute
The PGAA extension lets you provision a separate, ephemeral, scale-to-zero compute resource that is powered by Postgres and optimized for efficient batch query execution over columnar data.
External lakehouse ecosystem integration
Use standard SQL to write lakehouse tables to external object storage and query them just like any Postgres table. Lakehouse table formats are 5x smaller on disk compared to Postgres tables and indexes.
Storage locations
Store lakehouse tables in flexible storage locations that are up to 18x more cost-efficient versus solid state drives—including Amazon S3, MinIO, or the local filesystem. Choose between managed storage locations, with lifecycle and security fully managed for you, or bring your own.
Getting Started
Ready to dig in? Sign up for preview access to gain a deeper understanding of Analytics Accelerator and learn how to get started with the PGAA extension.
Resources
EDB Postgres AI Analytics Overview
Operational Analytics Use Case
Dynamic Analytics Use Case
Improve Analytics Insight Without Sacrificing Performance
EDB Mission Control: A Postgres Lakehouse Innovation
EDB Postgres AI
EDB Postgres AI is an intelligent platform for transactional, analytical, and AI workloads that meets you wherever you are—on premises or on any cloud, anywhere, and on appliances of choice. Get access to the most flexible, open, and extensible general-purpose database, break data silos, and launch new AI initiatives with the highest assurance of security, compliance, and availability.
Use Case: Customer 360
EDB Postgres AI powers Customer 360 use cases by unifying transactional, analytical, and AI data stores within a single Postgres environment. Use Analytics Accelerator’s vectorized query engine to provide 30x faster query performance, on average, across data in Postgres and integrated object storage—unlocking the full potential of your customer data.