Re: inheritance, and plans - Mailing list pgsql-performance

From Tom Lane
Subject Re: inheritance, and plans
Date
Msg-id 23440.1234118045@sss.pgh.pa.us
Whole thread Raw
In response to Re: inheritance, and plans  (Andrew Gierth <andrew@tao11.riddles.org.uk>)
Responses Re: inheritance, and plans  (Andrew Gierth <andrew@tao11.riddles.org.uk>)
Re: inheritance, and plans  (Grzegorz Jaśkiewicz <gryzman@gmail.com>)
List pgsql-performance
Andrew Gierth <andrew@tao11.riddles.org.uk> writes:
> Type-dependent selection of operators has already been done as part of
> parse analysis, no? And the domain -> base conversion is purely a
> relabelling, no? So what semantic change is possible as a result?

Domain conversions are *not* simply relabellings.  It's possible now to
have domain-specific functions/operators, and the likely future
evolution of the system is to make that work better rather than remove it.

It's possible that there are specific cases where the UNION optimization
checks could allow domains to be treated as their base types, but
blindly smashing both sides of the check to base is going to break more
cases than it fixes.

            regards, tom lane

pgsql-performance by date:

Previous
From: Andrew Gierth
Date:
Subject: Re: inheritance, and plans
Next
From: Andrew Gierth
Date:
Subject: Re: inheritance, and plans