## tender wang (tndrw...@gmail.com):
> But I want to know why we don't prune when just have latter partition key
> in whereClause.
Start with the high level documentation
https://www.postgresql.org/docs/current/sql-createtable.html#SQL-CREATETABLE-PARTITION
where the 5th paragraph points you to
h
On Thu, 10 Aug 2023 at 12:16, tender wang wrote:
>
> I have an range partition and query below:
> create table p_range(a int, b int) partition by range (a,b); create table
> p_range1 partition of p_range for values from (1,1) to (3,3); create table
> p_range2 partition of p_range for values from
I have an range partition and query below:
create table p_range(a int, b int) partition by range (a,b); create table
p_range1 partition of p_range for values from (1,1) to (3,3); create table
p_range2 partition of p_range for values from (4,4) to (6,6); explain
select * from p_range where b =2;
