PolarDB for PostgreSQL (Compatible with Oracle) provides several query optimization features for partitioned tables. You can leverage those features to improve query efficiency, especially when queries involve large amounts of data.
PolarDB for PostgreSQL (Compatible with Oracle) supports partition pruning and partition-wise joins, which can dramatically improve the speed of queries on partition keys.