Partition Pruning Articles

Page 1 of 1 (4 articles)

7/8/2026 • EN

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

Techniques for achieving partition pruning in PostgreSQL when filtering by non-partition key columns.

Database Optimization Partition Pruning postgresql Query Performance sql

Haki Benita

4/29/2026 • EN

Hidden Partitioning: How Iceberg Eliminates Accidental Full Table Scans

Explains how Apache Iceberg's hidden partitioning prevents accidental full table scans by automatically mapping source column filters to partition values.

Apache Iceberg Data Lake Hidden Partitioning Partition Pruning Table Scan

Alex Merced

4/29/2026 • EN

Partitioning, Sharding, and Data Distribution Strategies

Explores data partitioning strategies like hash, range, and list partitioning for query engines, focusing on performance and data distribution.

Data Skew Hash Partitioning List Partitioning Partition Pruning Range Partitioning

Alex Merced

2/19/2026 • EN

Partition and Organize Data for Performance

Explains data partitioning and organization strategies to drastically improve query performance in analytical databases.

Analytical Workloads Columnar Formats Data Partitioning Partition Pruning Query Optimization

Alex Merced

Partition Pruning Articles

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

Hidden Partitioning: How Iceberg Eliminates Accidental Full Table Scans

Partitioning, Sharding, and Data Distribution Strategies

Partition and Organize Data for Performance

Select Language

We use cookies