The query performance of a PolarDB for PostgreSQL (Compatible with Oracle) partitioned table is higher than that of a regular table that has the same amount of data. You can use partitioned tables to handle large amounts of data with a higher query efficiency.
PolarDB for PostgreSQL (Compatible with Oracle) supports partition pruning and partition-wise join features. These features can significantly improve the performance of queries whose conditions are specified based on partition keys.