PostgreSQL - Table Partitioning
Consider the following partitioned table:
CREATE TABLE logs (id SERIAL, log_date DATE) PARTITION BY RANGE (log_date);Which partitions will PostgreSQL scan to answer this query?
CREATE TABLE logs_2022 PARTITION OF logs FOR VALUES FROM ('2022-01-01') TO ('2023-01-01');
CREATE TABLE logs_2023 PARTITION OF logs FOR VALUES FROM ('2023-01-01') TO ('2024-01-01');
SELECT COUNT(*) FROM logs WHERE log_date >= '2023-06-01' AND log_date < '2023-07-01';
