Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1ertI7-0007Hn-C0 for pgsql-hackers@arkaria.postgresql.org; Fri, 02 Mar 2018 22:36:40 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1ertI5-0003xK-Fv for pgsql-hackers@arkaria.postgresql.org; Fri, 02 Mar 2018 22:36:37 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1ertI5-0003xA-4x for pgsql-hackers@lists.postgresql.org; Fri, 02 Mar 2018 22:36:37 +0000 Received: from mail.postgrespro.ru ([93.174.131.138]) by magus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1ertI1-0006oE-7k for pgsql-hackers@lists.postgresql.org; Fri, 02 Mar 2018 22:36:36 +0000 Received: from localhost (localhost [127.0.0.1]) by mail.postgrespro.ru (Postfix) with ESMTP id A4F4C21CC007; Sat, 3 Mar 2018 01:36:31 +0300 (MSK) X-Virus-Scanned: Debian amavisd-new at postgrespro.ru X-Spam-Flag: NO X-Spam-Score: 0 X-Spam-Level: X-Spam-Status: No, score=x tagged_above=-99 required=4 WHITELISTED tests=[] autolearn=unavailable Received: from [10.100.236.30] (unknown [195.82.154.27]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (Client did not present a certificate) by mail.postgrespro.ru (Postfix) with ESMTPSA id 6074D21CA15F; Sat, 3 Mar 2018 01:36:31 +0300 (MSK) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=postgrespro.ru; s=mail; t=1520030191; bh=SzNBqTUXaypZUUZ3JfDdckLqsthUo5C+ab5/hohTbfo=; h=Subject:To:Cc:References:From:Date:In-Reply-To; b=lygOuTFg/VVNJ6+KSSF9mgN+ryzTFI9tkJkdINwcvl7ZfILctvfg2mVfoE4giRL94 pHLuKPSgtd3EDssV+6a8ifhopt4f3JLxQDxlv4y6tvapxDfbnhyFSlmkLDC8Td49yW CHitOx9Vz2tJMo2DwoNOIU2plLKDd+aqmi86IjP4= Subject: Re: [PATCH] Opclass parameters To: Nikolay Shaplov , pgsql-hackers@lists.postgresql.org, obartunov@gmail.com Cc: PostgreSQL mailing lists References: <15077864.qMPJiTemUy@x200m> <2803786.3sFNWAn8Pn@x200m> From: Nikita Glukhov Organization: Postgres Professional Message-ID: <6382cb29-83d8-90f2-1dbb-b4ac606cbf1f@postgrespro.ru> Date: Sat, 3 Mar 2018 01:32:58 +0300 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101 Thunderbird/52.6.0 MIME-Version: 1.0 In-Reply-To: <2803786.3sFNWAn8Pn@x200m> Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 8bit Content-Language: en-US List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 02.03.2018 19:12, Nikolay Shaplov wrote: > В письме от 1 марта 2018 23:02:20 пользователь Oleg Bartunov написал: >>> 2. Your patch does not provide any example of your new tool usage. In my >>> prototype patch I've shown the implementation of opclass options for >>> intarray. May be you should do the same. (Use my example it will be more >>> easy then do it from scratch). It will give more understanding of how >>> this improvement can be used. >> Hey, look on patches, there are many examples ! > Oups...Sorry. I've looked at the patch from commitfest > https://commitfest.postgresql.org/17/1559/ and it have shown only the first > file. And When I read the letter I did not pay attention to attachments at > all. So I was sure there is only one there. > > Yes. Now I see seven examples. But I think seven it is too many. > For each case a reviewer should make consideration if this parameter worth > moving to opclass options, or fixed definition in the C code is quite ok. > Doing it for whole bunch, may make it messy. I think, it would be good to > commit an implementation of opclass options, with a good example of usage. And > then commit patches for all cases where these options can be used. There are 5 examples for GiST opclasses, not 7, and they are almost identical -- in all of them added 'siglen' parameter for signature length specification. > But since it is now "Rejected with feedback", let's wait till autumn. We don't want to wait that long. But now we only need to сome to an agreement about CREATE INDEX syntax and where to store the opclass parameters. -- Nikita Glukhov Postgres Professional: http://www.postgrespro.com The Russian Postgres Company