Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WcurB-0008G1-35 for pgsql-hackers@arkaria.postgresql.org; Wed, 23 Apr 2014 10:56:49 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1WcurA-0000Bl-J1 for pgsql-hackers@arkaria.postgresql.org; Wed, 23 Apr 2014 10:56:48 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Wcur7-0000Ba-VB for pgsql-hackers@postgresql.org; Wed, 23 Apr 2014 10:56:46 +0000 Received: from momjian.us ([72.94.173.45]) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Wcuqy-0000S0-HE for pgsql-hackers@postgresql.org; Wed, 23 Apr 2014 10:56:45 +0000 Received: from bruce by momjian.us with local (Exim 4.72) (envelope-from ) id 1Wcuqs-0000rF-VT; Wed, 23 Apr 2014 06:56:30 -0400 Date: Wed, 23 Apr 2014 06:56:30 -0400 From: Bruce Momjian To: Petr Jelinek Cc: Peter Geoghegan , Greg Stark , Tom Lane , Robert Haas , Heikki Linnakangas , Andrew Dunstan , "pgsql-hackers@postgresql.org" Subject: Re: Re: default opclass for jsonb (was Re: Call for GIST/GIN/SP-GIST opclass documentation) Message-ID: <20140423105630.GQ10046@momjian.us> References: <29030.1396993582@sss.pgh.pa.us> <534475B7.6020908@dunslane.net> <5344EAA4.1050605@vmware.com> <30137.1397057056@sss.pgh.pa.us> <20140422223230.GL10046@momjian.us> <535777DA.3000203@2ndquadrant.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <535777DA.3000203@2ndquadrant.com> User-Agent: Mutt/1.5.20 (2009-06-14) 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 On Wed, Apr 23, 2014 at 10:20:42AM +0200, Petr Jelinek wrote: > On 23/04/14 00:40, Peter Geoghegan wrote: > >On Tue, Apr 22, 2014 at 3:32 PM, Bruce Momjian wrote: > >>Where are we on the default JSONB opclass change? > > > >FWIW, I still don't have any strong opinion here. I defer to others on > >this question. > > > > I vote for changing it, even though neither option is ideal I think > that given the nature of datatype the current default will break > inserts for common usage pattern and that's much worse than not > being able to use the index for some operators. I agree. We should choose the most general option as the default. -- Bruce Momjian http://momjian.us EnterpriseDB http://enterprisedb.com + Everyone has their own god. + -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers