Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WjFFS-0005aO-TR for pgsql-hackers@arkaria.postgresql.org; Sat, 10 May 2014 21:56:03 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1WjFFS-0004SS-Cl for pgsql-hackers@arkaria.postgresql.org; Sat, 10 May 2014 21:56:02 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WjFFR-0004SK-8b for pgsql-hackers@postgresql.org; Sat, 10 May 2014 21:56:01 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WjFFP-0003mE-06 for pgsql-hackers@postgresql.org; Sat, 10 May 2014 21:56:00 +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 s4ALtik5020592; Sat, 10 May 2014 17:55:44 -0400 From: Tom Lane To: Andrew Dunstan cc: Heikki Linnakangas , Greg Stark , Bruce Momjian , Gavin Flower , "David E. Wheeler" , Robert Haas , Peter Geoghegan , "pgsql-hackers@postgresql.org" Subject: Re: default opclass for jsonb (was Re: Call for GIST/GIN/SP-GIST opclass documentation) In-reply-to: <536E9386.6050701@dunslane.net> References: <16769.1399407530@sss.pgh.pa.us> <20140506212020.GK30817@momjian.us> <57E8AA44-F816-45F2-BB61-5A854FFB0A97@justatheory.com> <28554.1399414853@sss.pgh.pa.us> <20140508134701.GO30817@momjian.us> <5819.1399558614@sss.pgh.pa.us> <1888.1399588751@sss.pgh.pa.us> <20140509033405.GA23254@momjian.us> <536C550F.50108@archidevsys.co.nz> <18360.1399633457@sss.pgh.pa.us> <20140509135336.GC23254@momjian.us> <28961.1399668272@sss.pgh.pa.us> <536E8F3A.40706@vmware.com> <536E9386.6050701@dunslane.net> Comments: In-reply-to Andrew Dunstan message dated "Sat, 10 May 2014 17:00:54 -0400" Date: Sat, 10 May 2014 17:55:44 -0400 Message-ID: <20591.1399758944@sss.pgh.pa.us> X-Pg-Spam-Score: -2.6 (--) 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 Andrew Dunstan writes: > On 05/10/2014 04:42 PM, Heikki Linnakangas wrote: >> Whether the opclasses use hashing to shorten the key is an orthogonal >> property, and IMHO not as important. To reflect that, I suggest that >> we name the opclasses: >> >> json_path_ops >> json_value_ops >> >> or something along those lines. > That looks like the first suggestion I've actually liked and that users > will be able to understand. I'd prefer to stick with just "jsonb_ops" for the default opclass. Also, "jsonb_value_ops" is not le mot juste anyway, because that opclass doesn't just index values it also indexes keys (if I've got the JSON terminology straight). However, I could accept renaming jsonb_hash_ops to jsonb_path_ops, as long as we do it PDQ. regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers