Getting Started

• Analytics Generic Concepts
  • Architectures
    • Data warehouses
    • Data lakes
    • Data lakehouse
  • Key technologies
    • Columnar storage formats
    • Vectorized query engines
    • Separation of storage and compute
    • Open table formats
  • Core concepts
    • OLAP / OLTP
    • ETL / ELT
    • Data tiering
    • Semantic search
    • Vector embeddings
    • Retrieval augmented generation (RAG)
  • Additional concepts
    • Multi-engine interoperability
    • Data freshness and latency
  • Explore next
• Analytics Accelerator Concepts
  • EDB’s vision for analytics on Postgres
  • Key EDB solutions and technologies
    • EDB Postgres Lakehouse
    • Vectorized query optimization
    • EDB Postgres Distributed (PGD) and Tiered Tables
    • Advanced query optimization
  • Analytics and AI/ML workloads
  • How EDB implements analytics across products
    • Hybrid Manager (HM)
    • EDB Postgres Advanced Server / Extended Server
    • EDB Postgres Distributed (PGD)
  • Explore next
• Analytics Terminology
  • Apache Iceberg
  • Delta Lake
  • Data Lakehouse
  • EDB Postgres Lakehouse Cluster
  • EDB Postgres Distributed (PGD)
  • Tiered Tables
  • PGAA (Analytics Accelerator)
  • PGFS (Postgres File System)
  • AutoPartition
  • BDR Analytics Table
  • Iceberg Catalog
  • Lakekeeper
  • Open Table Formats
  • Vectorized Query Engine
  • Data Tiering
  • Separation of Storage and Compute
  • Next steps
• Analytics Accelerator Architecture
  • Architecture Overview
  • Core Components
    • EDB Postgres Distributed Foundation
    • Lakehouse Query Engine
    • Storage Abstraction Layer
    • Table Format Integration
  • Architectural Layers
    • Ingestion and Transaction Layer
    • Storage and Metadata Layer
    • Query and Transformation Layer
    • Access and Integration Layer
  • Data Flow Patterns
    • Operational to Analytical Pipeline
    • Direct Lakehouse Access
    • Multi-Engine Collaboration
  • Performance Architecture
    • Query Optimization Pipeline
    • Caching Hierarchy
    • Parallel Execution
  • High Availability and Resilience
    • Transactional Tier Availability
    • Analytical Tier Availability
    • Catalog Resilience
  • Security Architecture
    • Access Control Framework
    • Encryption Strategy
    • Audit and Compliance
  • Deployment Patterns
    • Managed Service Deployment
    • Self-Managed Deployment
    • Hybrid Deployment
• Analytics Accelerator Quick Start
  • Introduction
    • What to know
    • Basic architecture
  • Getting started
    • Create a Lakehouse node
  • Operating a Lakehouse node
    • Connect to the node
    • Understand the constraints
  • Inspect the benchmark datasets
  • Query the benchmark datasets
• Reference - EDB Postgres® AI Lakehouse
  • Benchmarking datasets
  • Queries
  • Delta Lake Table tools
    • Creating Delta Lake Tables
  • DirectScan and fallback modes
    • DirectScan
    • Using EXPLAIN to check the query plan
  • User management
  • Loading data
    • Bringing your own data
  • PGAA functions reference
    • Synopsis
    • Parameters
    • Returns
    • Synopsis
    • Parameters
    • Returns
  • PGAA functions reference
    • pgaa.create_storage_location
  • Supported AWS instances