Get the latest tech news

How to Achieve Pruning When Querying by Non-Partitioned Columns in PostgreSQL

One of the most valuable things about partitioned tables is pruning - the database's ability to eliminate entire partitions based on a query predicate. Under conventional wisdom, pruning can only be achieved when querying by the partition key - this makes choosing the right key extremely difficult.

None

Get the Android app