Re: Re: default opclass for jsonb (was Re: Call for GIST/GIN/SP-GIST opclass documentation)

From: Petr Jelinek <petr(at)2ndquadrant(dot)com>
To: Peter Geoghegan <pg(at)heroku(dot)com>, Bruce Momjian <bruce(at)momjian(dot)us>
Cc: Greg Stark <stark(at)mit(dot)edu>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Robert Haas <robertmhaas(at)gmail(dot)com>, Heikki Linnakangas <hlinnakangas(at)vmware(dot)com>, Andrew Dunstan <andrew(at)dunslane(dot)net>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Re: default opclass for jsonb (was Re: Call for GIST/GIN/SP-GIST opclass documentation)
Date: 2014-04-23 08:20:42
Message-ID: 535777DA.3000203@2ndquadrant.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs pgsql-hackers

On 23/04/14 00:40, Peter Geoghegan wrote:
> On Tue, Apr 22, 2014 at 3:32 PM, Bruce Momjian <bruce(at)momjian(dot)us> 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.

--
Petr Jelinek http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services

In response to

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Amit Langote 2014-04-23 09:15:01 Typo in doc/src/sgml/monitoring.sgml? s/tranche/trance?
Previous Message Tom Lane 2014-04-23 00:50:20 Re: Re: default opclass for jsonb (was Re: Call for GIST/GIN/SP-GIST opclass documentation)

Browse pgsql-hackers by date

  From Date Subject
Next Message David Rowley 2014-04-23 08:26:40 Re: 9.4 Proposal: Initdb creates a single table
Previous Message Andres Freund 2014-04-23 08:11:23 Re: Missing pfree in logical_heap_rewrite_flush_mappings()