supports cross-node parallel execution, distributing SQL queries across multiple compute nodes. This accelerates analytical queries for, maximizes PolarFileSystem I/O throughput, and improves CPU and memory utilization across all compute nodes.
Prerequisites
-
For clusters created before V1.1.20 (January 2022), enable this feature manually. Go to the Quota Center, find the PolarDB PG Cross-node Parallel Execution quota, and click Request in the Operation column.
-
The minor engine version of must be V1.1.11 or later. To upgrade, see .
Benefits
Cross-node parallel execution offers these benefits:
-
Hybrid transactional and analytical processing (HTAP):
-
Run analytical queries on transactional (TP) data in real time.
-
Analytical read-only nodes can be physically isolated from TP read-only nodes, preventing analytical queries from affecting TP services.
-
-
Scales with the decoupled storage-compute architecture of:
-
Add read-only nodes as needed. New nodes join the distributed parallel computing process without data resharding.
-
Prevents data skew.
-
Scenarios
Suited for lightweight analytical workloads in daily operations, such as account reconciliation.
Features
-
Cross-node parallel execution runs analytical queries and provides HTAP capabilities..