Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Y0XOQ-0006WV-8T for pgsql-hackers@arkaria.postgresql.org; Mon, 15 Dec 2014 15:17:02 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1Y0XOP-0006Ci-Nc for pgsql-hackers@arkaria.postgresql.org; Mon, 15 Dec 2014 15:17:01 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1Y0XON-00069H-PZ for pgsql-hackers@postgresql.org; Mon, 15 Dec 2014 15:16:59 +0000 Received: from smtp-outbound-2.vmware.com ([208.91.2.13]) by makus.postgresql.org with esmtps (TLS1.0:DHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.80) (envelope-from ) id 1Y0XOF-0002lb-Qa for pgsql-hackers@postgresql.org; Mon, 15 Dec 2014 15:16:57 +0000 Received: from sc9-mailhost3.vmware.com (sc9-mailhost3.vmware.com [10.113.161.73]) by smtp-outbound-2.vmware.com (Postfix) with ESMTP id EE1CC283E2; Mon, 15 Dec 2014 07:16:49 -0800 (PST) Received: from EX13-CAS-012.vmware.com (EX13-CAS-012.vmware.com [10.113.191.64]) by sc9-mailhost3.vmware.com (Postfix) with ESMTP id E83CE41132; Mon, 15 Dec 2014 07:16:49 -0800 (PST) Received: from EX13-MBX-024.vmware.com (10.113.191.44) by EX13-MBX-008.vmware.com (10.113.191.28) with Microsoft SMTP Server (TLS) id 15.0.913.22; Mon, 15 Dec 2014 07:16:44 -0800 Received: from [192.168.1.90] (10.113.160.246) by EX13-MBX-024.vmware.com (10.113.191.44) with Microsoft SMTP Server (TLS) id 15.0.913.22; Mon, 15 Dec 2014 07:16:43 -0800 Message-ID: <548EFB45.1000705@vmware.com> Date: Mon, 15 Dec 2014 17:16:21 +0200 From: Heikki Linnakangas Organization: VMware User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:31.0) Gecko/20100101 Icedove/31.3.0 MIME-Version: 1.0 To: Emre Hasegeli , Alexander Korotkov CC: PostgreSQL Hackers Subject: Re: KNN-GiST with recheck References: <20140803134809.GA58181@hasegeli-2.local> In-Reply-To: <20140803134809.GA58181@hasegeli-2.local> Content-Type: text/plain; charset="utf-8"; format=flowed Content-Transfer-Encoding: 7bit X-Originating-IP: [10.113.160.246] X-ClientProxiedBy: EX13-CAS-013.vmware.com (10.113.191.65) To EX13-MBX-024.vmware.com (10.113.191.44) X-Pg-Spam-Score: -6.9 (------) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-hackers Precedence: bulk Sender: pgsql-hackers-owner@postgresql.org On 08/03/2014 04:48 PM, Emre Hasegeli wrote: >>> 1. This patch introduces a new "polygon <-> point" operator. That seems >>> useful on its own, with or without this patch. >> >> Yeah, but exact-knn cant come with no one implementation. But it would >> better come in a separate patch. > > I tried to split them. Separated patches are attached. I changed > the order of the arguments as point <-> polygon, because point was > the first one on all the others. Its commutator was required for > the index, so I added it on the second patch. I also added tests > for the operator. I think it is ready for committer as a separate > patch. We can add it to the open CommitFest. Ok, committed this part now with minor changes. The implementation was copy-pasted from circle <-> polygon, so I put the common logic to a dist_ppoly_internal function, and called that in both dist_cpoly and dist_ppoly. I was surprised that there were no documentation changes in the patch, but looking at the docs, we just list the geometric operators without explaining what the argument types are. That's not very comprehensive, might be good to expand the docs on that, but it's not this patch's fault. - Heikki -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers