Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WXvj5-0000Dv-H2 for pgsql-hackers@arkaria.postgresql.org; Wed, 09 Apr 2014 16:51:51 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1WXvj5-0001oM-01 for pgsql-hackers@arkaria.postgresql.org; Wed, 09 Apr 2014 16:51:51 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WXvj3-0001mY-3H for pgsql-hackers@postgresql.org; Wed, 09 Apr 2014 16:51:49 +0000 Received: from mail-ob0-f178.google.com ([209.85.214.178]) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WXvj0-0004Hz-Fm for pgsql-hackers@postgresql.org; Wed, 09 Apr 2014 16:51:48 +0000 Received: by mail-ob0-f178.google.com with SMTP id wp18so3044849obc.9 for ; Wed, 09 Apr 2014 09:51:43 -0700 (PDT) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:in-reply-to:references:date :message-id:subject:from:to:cc:content-type; bh=defnMAIM/mK5gzVtmsKjZnh6XeN6qdxwtmmsH4vR2n8=; b=jClp9eP04ZgJv1eQARrZgV3dKoXtDuA0IcD12avsyF1/2+tWCrIffgrRj4pr/GOF1X V+tPW1gKRZXokwnWtCKXKho2JRW9RjFihSFnITDtYKvvPldLuZPSlLGdyK+PqwxJuTtr vvRECObYugqfbG18X1ETviwGHy3uA3HQAUGw2cqkUEXqAehdL4uIw65fPtWcyY1kN5GG 78q6O/CG4F7L7aKoCL2bD076HFc+wBG/U6HqU0FEcsLX9uEOyfxzNGiuc2jzdkpmoans Z1qVqBkoeZxJ46uXP+cAM1RZWpj7umPjETOTDfOjouBaF9L8BoPthIEmYr2eaBqeGLCq fIWQ== X-Gm-Message-State: ALoCoQlXQVfb/2jG6nXL1QYJKBvmNhj9QSp/DTawOo+fd+muE97vOTvBlaEhyU/KvI58eE2brzVw MIME-Version: 1.0 X-Received: by 10.183.3.102 with SMTP id bv6mr9706898obd.18.1397062303864; Wed, 09 Apr 2014 09:51:43 -0700 (PDT) Received: by 10.182.233.228 with HTTP; Wed, 9 Apr 2014 09:51:43 -0700 (PDT) In-Reply-To: <30137.1397057056@sss.pgh.pa.us> References: <27299.1396989666@sss.pgh.pa.us> <28589.1396992841@sss.pgh.pa.us> <29030.1396993582@sss.pgh.pa.us> <534475B7.6020908@dunslane.net> <5344EAA4.1050605@vmware.com> <30137.1397057056@sss.pgh.pa.us> Date: Wed, 9 Apr 2014 09:51:43 -0700 Message-ID: Subject: Re: default opclass for jsonb (was Re: Call for GIST/GIN/SP-GIST opclass documentation) From: Peter Geoghegan To: Tom Lane Cc: Robert Haas , Heikki Linnakangas , Andrew Dunstan , "pgsql-hackers@postgresql.org" Content-Type: text/plain; charset=UTF-8 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 9, 2014 at 8:24 AM, Tom Lane wrote: >> Maybe we should make *neither* of these the default opclass, and give >> *neither* the name json_ops. > > There's definitely something to be said for that. Default opclasses are > sensible when there's basically only one behavior that's interesting for > most people. We can already see that that's not going to be the case > for jsonb indexes, at least not with the currently available alternatives. I've heard worse ideas. -- Peter Geoghegan -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers