Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256)
	(Exim 4.89)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1h0wRi-0006zk-OF
	for pgsql-hackers@arkaria.postgresql.org; Mon, 04 Mar 2019 22:52:30 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.89)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1h0wRh-0005WN-3s
	for pgsql-hackers@arkaria.postgresql.org; Mon, 04 Mar 2019 22:52:29 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256)
	(Exim 4.89)
	(envelope-from <tgl@sss.pgh.pa.us>)
	id 1h0wRg-0005VX-OV
	for pgsql-hackers@lists.postgresql.org; Mon, 04 Mar 2019 22:52:28 +0000
Received: from sss.pgh.pa.us ([66.207.139.130])
	by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256)
	(Exim 4.89)
	(envelope-from <tgl@sss.pgh.pa.us>)
	id 1h0wRd-0000Pw-Kx
	for pgsql-hackers@lists.postgresql.org; Mon, 04 Mar 2019 22:52:27 +0000
Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1])
	by sss.pgh.pa.us (8.14.4/8.14.4) with ESMTP id x24MqNWJ031608;
	Mon, 4 Mar 2019 17:52:23 -0500
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Paul Ramsey <pramsey@cleverelephant.ca>
cc: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Subject: Re: Allowing extensions to supply operator-/function-specific info
In-reply-to: <B256FF5D-EF73-4FDE-A50D-9C9E9FB3B159@cleverelephant.ca>
References: <15193.1548028093@sss.pgh.pa.us> <6953.1548297558@sss.pgh.pa.us>
 <6044.1548524131@sss.pgh.pa.us>
 <CA+TgmoYkLjVcbZZ8PYyaCTMYZJCQ8eiod8MSRMDaczjBw=a0bQ@mail.gmail.com>
 <19993.1548697885@sss.pgh.pa.us>
 <CACowWR3jZ4Xo1atU5xTDpEoeeKSw1==sKPhCy3a29HtcE9oQVQ@mail.gmail.com>
 <7671.1551135674@sss.pgh.pa.us>
 <CACowWR3_RyPSYO6a8TVLZ7KnL_rDNh2ywkSTeqFmrAPpP4y6-g@mail.gmail.com>
 <11051.1551139751@sss.pgh.pa.us>
 <CACowWR1ycbLx0t7WwT8uuJnK7E3U+tfzKXBRPaQrgHiCG+hvbA@mail.gmail.com>
 <14747.1551219541@sss.pgh.pa.us>
 <91BAE1F4-7C16-4F87-849F-B01175A8D7D8@cleverelephant.ca>
 <17244.1551226168@sss.pgh.pa.us>
 <74C11775-67A7-48D2-B1E3-24C52A686F86@cleverelephant.ca>
 <15086.1551310830@sss.pgh.pa.us>
 <BBB5F584-5036-4A11-B5FF-D30632EC9E1A@cleverelephant.ca>
 <24277.1551320775@sss.pgh.pa.us>
 <CACowWR3fZRV6fGrH7vsVLqLz0TQJpmzb=wcipqAQBVZSn0sT4g@mail.gmail.com>
 <26156.1551734021@sss.pgh.pa.us>
 <B256FF5D-EF73-4FDE-A50D-9C9E9FB3B159@cleverelephant.ca>
Comments: In-reply-to Paul Ramsey <pramsey@cleverelephant.ca>
	message dated "Mon, 04 Mar 2019 13:59:25 -0800"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <31606.1551739943.1@sss.pgh.pa.us>
Content-Transfer-Encoding: quoted-printable
Date: Mon, 04 Mar 2019 17:52:23 -0500
Message-ID: <31607.1551739943@sss.pgh.pa.us>
List-Id: <pgsql-hackers.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-hackers@lists.postgresql.org>
List-Owner: <mailto:pgsql-hackers-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-hackers>
Precedence: bulk

Paul Ramsey <pramsey@cleverelephant.ca> writes:
> Gotcha, done and now have an implementation that passes all our regressi=
on tests.

Very cool!  So the next step, I guess, is to address your original problem
by cranking up the cost estimates for these functions --- have you tried
that yet?  In principle you should be able to do that and not have any
bad planning side-effects, but this is all pretty new territory so maybe
some problems remain to be ironed out.

BTW, if you'd like me to review the code you added for this, I'd be happy
to do so.  I've never looked at PostGIS' innards, but probably I can make
sense of the code for this despite that.

			regards, tom lane