Re: [HACKERS] Default gin operator class of jsonb failing with index row size maximum reached

2014-04-08 Thread Peter Geoghegan
On Tue, Apr 8, 2014 at 4:07 PM, Michael Paquier wrote: > If this is a known limitation and no fix is planned for 9.4, could it > be possible to document it appropriately for this release? This would > surprise users. It looks like the default GIN opclass will be changed, so it becomes a matter of

Re: [HACKERS] Default gin operator class of jsonb failing with index row size maximum reached

2014-04-08 Thread Michael Paquier
On Wed, Apr 9, 2014 at 6:48 AM, Tom Lane wrote: > Oleg Bartunov writes: >> We are working to avoid this limitation. > > What do you mean by that ... do you see it as something that could be > fixed quickly, or is this a long-term improvement project? If this is a known limitation and no fix is pl

Re: [HACKERS] Default gin operator class of jsonb failing with index row size maximum reached

2014-04-08 Thread Oleg Bartunov
On Wed, Apr 9, 2014 at 1:48 AM, Tom Lane wrote: > Oleg Bartunov writes: >> We are working to avoid this limitation. > > What do you mean by that ... do you see it as something that could be > fixed quickly, or is this a long-term improvement project? Unfortunately, It's long-term project VODKA,

Re: [HACKERS] Default gin operator class of jsonb failing with index row size maximum reached

2014-04-08 Thread Tom Lane
Oleg Bartunov writes: > We are working to avoid this limitation. What do you mean by that ... do you see it as something that could be fixed quickly, or is this a long-term improvement project? regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@pos

Re: [HACKERS] Default gin operator class of jsonb failing with index row size maximum reached

2014-04-08 Thread Oleg Bartunov
We are working to avoid this limitation. On Tue, Apr 8, 2014 at 10:54 PM, Peter Geoghegan wrote: > On Mon, Apr 7, 2014 at 8:29 PM, Michael Paquier > wrote: >> Documentation of jsonb tells that jsonb documents should be kept at a >> reasonable size to reduce lock contention, but there is no menti

Re: [HACKERS] Default gin operator class of jsonb failing with index row size maximum reached

2014-04-08 Thread Peter Geoghegan
On Mon, Apr 7, 2014 at 8:29 PM, Michael Paquier wrote: > Documentation of jsonb tells that jsonb documents should be kept at a > reasonable size to reduce lock contention, but there is no mention of > size limitation for indexes: > http://www.postgresql.org/docs/devel/static/datatype-json.html It

[HACKERS] Default gin operator class of jsonb failing with index row size maximum reached

2014-04-07 Thread Michael Paquier
Hi all, While doing some tests with jsonb, I found a failure as told in $subject: =# create table data_jsonb (data jsonb); CREATE TABLE =# insert into data_jsonb ... tuple in the script attached INSERT 1 =# create index data_index on data_jsonb using gin(data); ERROR: 54000: index row size 1808 e