Services
  • 24×7×365 Technical Support
  • Migration to PostgreSQL
  • High Availability Deployment
  • Database Audit
  • Remote DBA for PostgreSQL
Products
  • Postgres Pro Enterprise
  • Postgres Pro Standard
  • Postgres Pro Shardman
  • Postgres Pro Enterprise Manager
  • Postgres Pro ProGate
  • Cloud Solutions
  • Postgres Extensions
Cases
Courses
Resources
  • Blog
  • Documentation
  • Webinars
  • Videos
  • Presentations
Community
  • Events
  • Books
  • Demo Database
  • Mailing List Archives
About
  • Leadership team
  • Partners
  • Customers
  • In the News
  • Press Releases
  • Press Info

Facebook
Postgres Pro
  • Services
    24×7×365 Technical Support Migration to PostgreSQL High Availability Deployment Database Audit Remote DBA for PostgreSQL
  • Products
    Postgres Pro Enterprise Postgres Pro Standard Postgres Pro Shardman Postgres Pro Enterprise Manager Postgres Pro ProGate Cloud Solutions Postgres Extensions
  • Cases
  • Courses
  • Resources
    Blog Documentation Webinars Videos Presentations
  • Community
    Events Books Demo Database Mailing List Archives
  • About
    Leadership team Partners Customers In the News Press Releases Press Info
Facebook
Request a Demo
Part IV. pgpro_axe
Prev UpPostgres Pro AXE 1.0.0 DocumentationHome Next

Part IV. pgpro_axe

pgpro_axe is a Postgres Pro columnar-vectorized analytics engine that, among the rest, supports storing the OLAP data as Parquet files in network, local, and S3 storages. This extension consists of the following components:

  • Proprietary Postgres Pro AXE components.

  • Postgres Pro core components.

  • DuckDB and its core functionality.

Table of Contents

21. Functions
21.1. Functions for Reading OLAP Data from a Storage
21.2. JSON Functions
21.3. Union Type Functions
21.4. MAP Functions
21.5. Aggregates Functions
21.6. Sampling Functions
21.7. Time Functions
21.8. DuckDB Administration Functions
21.9. Secrets Management Functions
22. Supported Extensions
23. Configuration Parameters
23.1. Security
23.2. Resource Management
23.3. Advanced
23.4. Storage
23.5. For Developers
24. Transactions
25. Syntax
25.1. Creating a Postgres Pro Table
25.2. Querying Postgres Pro Tables
25.3. Querying External Files
25.4. Joining Postgres Pro and External Data
25.5. Using duckdb.query()

Prev Up Next
20.3. Deleting Parquet Files Home Chapter 21. Functions
epub pdf
Есть вопросы? Напишите нам!

Соглашаюсь с условиями обработки персональных данных



✖
×
Postgres Pro AXE 1
Go to Postgres Pro AXE 1
Services
  • 24×7×365 Technical Support
  • Migration to PostgreSQL
  • High Availability Deployment
  • Database Audit
  • Remote DBA for PostgreSQL
Products
  • Postgres Pro Enterprise
  • Postgres Pro Standard
  • Postgres Pro Shardman
  • Postgres Pro Enterprise Manager
  • Postgres Pro ProGate
  • Cloud Solutions
  • Postgres Extensions
Cases
Courses
Resources
  • Blog
  • Documentation
  • Webinars
  • Videos
  • Presentations
Community
  • Events
  • Books
  • Demo Database
  • Mailing List Archives
About
  • Leadership team
  • Partners
  • Customers
  • In the News
  • Press Releases
  • Press Info
Products
  • Postgres Pro Enterprise
  • Postgres Pro Standard
  • Postgres Pro Shardman
  • Postgres Pro Enterprise Manager
  • Postgres Pro ProGate
  • Cloud Solutions
  • Postgres Extensions
Resources
  • Blog
  • Documentation
  • Webinars
  • Videos
  • Presentations
Services
  • 24×7×365 Technical Support
  • Migration to Postgres
  • High Availability Deployment
  • Database Audit
  • Remote DBA for PostgreSQL
Community
  • Events
  • Training Courses
  • Intro Book
  • Demo Database
  • Mailing List Archives
About
  • Leadership team
  • Partners
  • Cases
  • In the News
  • Press Releases
  • Press Info
Contacts
  • Neptune House, Marina Bay, office 207, Gibraltar, GX11 1AA
  • info@postgrespro.com
  • Facebook
Get in touch!



© Postgres Professional Europe Limited, 2015 — 2026
EULA EULA for Cloud Environments Privacy Policy GDPR Compliance Commitment
© Postgres Professional Europe Limited, 2015 — 2026
EULA
EULA for Cloud Environments
Privacy Policy
GDPR Compliance Commitment
By continuing to browse this website, you agree to the use of cookies. Go to Privacy Policy.