Reference

The reference section provides detailed technical specifications for the Postgres Analytics Accelerator (PGAA). Use these resources to fine-tune your configuration, understand supported data types, and manage your analytical tables.

For information on the PGFS functions for managing storage location, see the AI Factory PGFS documentation .

• Configuration parameters : The behavior of the PGAA extension is governed by Grand Unified Configuration (GUC) variables. These parameters allow you to switch executors, enable performance optimizations, and manage security credentials.

• Functions : PGAA introduces a suite of SQL functions for administrative tasks, such as mapping new tables, monitoring storage health, and launching maintenance background jobs.

• Table options : When mapping or creating analytical tables, specific options allow you to define how data is read from or written to your object store.

• Data types and definitions : PGAA maps native Postgres data types to optimized columnar formats in the data lake.

• Benchmark datasets : Access pre-configured schemas and data loading instructions for analytical datasets to baseline your performance.

• Configuration parameters
  • Executor engine
    • pgaa.executor_engine
    • pgaa.spark_connect_url
    • pgaa.spark_connect_extra_config
  • Query behavior
    • pgaa.enable_direct_scan
    • pgaa.direct_scan_fail_behavior
    • pgaa.enable_join_pushdown
    • pgaa.enable_groupby_pushdown
    • pgaa.ctas_intermediate_flush_size
    • pgaa.flush_task_interval_s
    • pgaa.max_in_memory_mb
    • pgaa.scan_aggregation_cost_factor
    • pgaa.scan_per_tuple_cost
    • pgaa.scan_startup_cost
    • pgaa.use_seafowl_cost_estimates
    • pgaa.write_lock_timeout_s
  • Seafowl
    • pgaa.autostart_seafowl
    • pgaa.autostart_seafowl_max_memory_mb
    • pgaa.autostart_seafowl_enable_metrics
    • pgaa.autostart_seafowl_metrics_host
    • pgaa.autostart_seafowl_metrics_port
    • pgaa.autostart_seafowl_enable_object_store_cache
    • pgaa.autostart_seafowl_log_level
    • pgaa.autostart_seafowl_path
    • pgaa.autostart_seafowl_port
    • pgaa.autostart_seafowl_tmp_dir
    • pgaa.enable_maintenance_worker
    • pgaa.maintenance_worker_sleep_interval
    • pgaa.seafowl_client_retry_base_ms
    • pgaa.seafowl_url
  • Catalog synchronization
    • pgaa.metastore_sync_poll_rate_s
    • pgaa.metastore_sync_stale_duration_s
    • pgaa.enable_metastore_sync_worker
  • Caching
    • pgaa.lakehouse_table_stats_cache_ttl_s
    • pgaa.autostart_seafowl_object_store_cache_capacity_mb
    • pgaa.autostart_seafowl_object_store_cache_min_fetch_size_kb
    • pgaa.autostart_seafowl_object_store_cache_ttl_s
  • Postgres Distributed (PGD) integration
    • pgaa.max_replication_lag_s
    • pgaa.flush_task_interval_s
  • DataFusion-inherited configurations
  • Executor engine
    • pgaa.executor_engine
    • pgaa.spark_connect_url
    • pgaa.spark_connect_extra_config
  • Query behavior
    • pgaa.enable_direct_scan
    • pgaa.direct_scan_fail_behavior
    • pgaa.enable_join_pushdown
    • pgaa.enable_groupby_pushdown
  • Seafowl
    • pgaa.autostart_seafowl
    • pgaa.autostart_seafowl_max_memory_mb
    • pgaa.autostart_seafowl_enable_metrics
    • pgaa.autostart_seafowl_metrics_host
    • pgaa.autostart_seafowl_metrics_port
  • Catalog synchronization
    • pgaa.metastore_sync_poll_rate_s
    • pgaa.metastore_sync_stale_duration_s
  • Caching
    • pgaa.lakehouse_table_stats_cache_ttl_s
  • DataFusion-inherited configurations
• Functions
  • Table functions
    • pgaa.list_analytics_tables()
    • pgaa.lakehouse_table_stats()
    • pgaa.test_storage_location()
    • pgaa.pgaa_version()
    • pgaa.add_catalog
  • Catalog functions
    • pgaa.add_catalog()
    • pgaa.update_catalog()
    • pgaa.delete_catalog()
    • pgaa.list_catalogs()
    • pgaa.import_catalog()
    • pgaa.attach_catalog()
    • pgaa.detach_catalog()
    • pgaa.test_catalog()
    • pgaa.list_catalog_tables()
    • pgaa.drop_catalog_tables()
  • Spark functions
    • pgaa.spark_sql()
    • pgaa.execute_compaction()
  • Background task functions
    • pgaa.launch_task()
  • Postgres Distributed (PGD) integration functions
    • pgaa.convert_to_analytics()
    • pgaa.convert_to_tiered_table()
    • pgaa.disable_analytics_replication()
    • pgaa.enable_analytics_replication()
    • pgaa.htap_table_stats_uncached()
    • pgaa.list_tiered_tables()
    • pgaa.restore_from_analytics()
  • Utility functions
    • pgaa._bench_replication()
• Table options
  • PGAA table options
    • Examples
  • PGD table options
    • Examples
  • Managing access methods
• Data types and definitions
  • Data types
  • Administrative enums and statuses
• Benchmark datasets