Horton

Re: [question] multil-column range partition prune

Christoph Moench-Tegeder <cmt@burggraben.net>

View thread View on postgr.es
From: Christoph Moench-Tegeder <cmt@burggraben.net>
To: tender wang <tndrwang@gmail.com>
Cc: pgsql-hackers@lists.postgresql.org
Date: 2023-08-10T12:45:54Z
Lists: pgsql-hackers 
## tender wang (tndrwang@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
https://www.postgresql.org/docs/current/functions-comparisons.html#ROW-WISE-COMPARISON
which has a detailed explanation of row comparison.

Regards,
Christoph

-- 
Spare Space.