Re: [question] multil-column range partition prune

From: Christoph Moench-Tegeder <cmt(at)burggraben(dot)net>
To: tender wang <tndrwang(at)gmail(dot)com>
Cc: pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: [question] multil-column range partition prune
Date: 2023-08-10 12:45:54
Message-ID: ZNTcAgIyqbXCvcNE@squirrel.exwg.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

## tender wang (tndrwang(at)gmail(dot)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.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Jimmy Angelakos 2023-08-10 12:47:09 Re: Adding a pg_servername() function
Previous Message Pavel Stehule 2023-08-10 12:43:50 Re: proposal: psql: show current user in prompt