Re: [sqlsmith] Failed assertion during partition pruning - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [sqlsmith] Failed assertion during partition pruning
Date
Msg-id 3289345.1612159073@sss.pgh.pa.us
Whole thread Raw
In response to Re: [sqlsmith] Failed assertion during partition pruning  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: [sqlsmith] Failed assertion during partition pruning
List pgsql-hackers
I wrote:
> David Rowley <dgrowleyml@gmail.com> writes:
>> Parent RT indexes are guaranteed to be lower than their children RT
>> indexes,

> I was intentionally avoiding that assumption ;-).  Maybe it buys enough
> to be worth the loss of generality, but ...

Oh, it's too late at night.  I now remember that the real problem
I had with that representation was that it cannot work for joinrels.
Currently we only apply this logic to partitioned baserels, but
don't you think it might someday be called on to optimize
partitionwise joins?

            regards, tom lane



pgsql-hackers by date:

Previous
From: Peter Smith
Date:
Subject: Re: Single transaction in the tablesync worker?
Next
From: Dilip Kumar
Date:
Subject: Re: Faulty HEAP_XMAX_LOCK_ONLY & HEAP_KEYS_UPDATED hintbit combination