Postgres Pro
Downloads
Home   >   mailing lists

Re: [question] multil-column range partition prune - Mailing list pgsql-hackers

From Christoph Moench-Tegeder
Subject Re: [question] multil-column range partition prune
Date
Msg-id ZNTcAgIyqbXCvcNE@squirrel.exwg.net
Whole thread Raw
In response to [question] multil-column range partition prune  (tender wang <tndrwang@gmail.com>)
List pgsql-hackers
Tree view 
## 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.

pgsql-hackers by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: proposal: psql: show current user in prompt
Next
From: Jimmy Angelakos
Date:
Subject: Re: Adding a pg_servername() function