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.