Chapter 24. Storages
Table of Contents
Storages are physical locations of Parquet files and shared directories.
Postgres Pro AXE supports the following types of storages:
Local storages: Arrays of disks on servers with Postgres Pro AXE installed.
Network storages: Network File System (NFS).
S3 storages.
You can select the appropriate storage type based on the characteristics shown in the table below.
Local Storage | Network Storage | S3 Storage | |
|---|---|---|---|
Throughput | High Determined by the number of NVMe disks in the array | Medium Limited by the capacity of the network interface of the server, network load, and network storage speed | Medium Limited by the capacity of the network interface of the server, network load, and S3 storage speed |
Data scalability | Medium Determined by the number and volume of NVMe disks | High | High |
Data distribution between servers | Not supported | Within the network of the organization | Global |
High availability provider | Postgres Pro AXE server administrator | NFS administrator | S3 provider |
Cost per terabyte and per one storage request | Low | Medium | Depends on the S3 provider |
Any directory structure can be used for storing the OLAP data, for example:
In a local or network storage:
root_path/db_name/schema_name/table_name
In an S3 storage:
s3://bucket/db_name/schema_name/table_name
The metadata of storages is stored in the pga_storage metadata table.