## 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 https://www.postgresql.org/docs/current/functions-comparisons.html#ROW-WISE-COMPARISON which has a detailed explanation of row comparison. Regards, Christoph -- Spare Space.
