Re: I'd like to discuss scaleout at PGCon - Mailing list pgsql-hackers

From Tom Lane
Subject Re: I'd like to discuss scaleout at PGCon
Date
Msg-id 6975.1527866834@sss.pgh.pa.us
Whole thread Raw
In response to Re: I'd like to discuss scaleout at PGCon  (Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>)
Responses Re: I'd like to discuss scaleout at PGCon
List pgsql-hackers
Ashutosh Bapat <ashutosh.bapat@enterprisedb.com> writes:
> In order to avoid double parsing, we might want to find a way to pass
> a "normalized" parse tree down to the foreign server. We need to
> normalize the OIDs in the parse tree since those may be different
> across the nodes.

I don't think this is a good idea at all.  It breaks any hope of
supporting remote servers that are not the identical version to the local
one (since their parsetrees might be different).  And "normalized OIDs"
sounds like "pie in the sky".  You might get away with asssuming that
built-in functions have stable OIDs, but you can't expect that for
functions in extensions.

            regards, tom lane


pgsql-hackers by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: ToDo: show size of partitioned table
Next
From: Ashutosh Bapat
Date:
Subject: Re: why partition pruning doesn't work?