Re: [GENERAL] could not split GIN page; no new items fit

2015-04-07 Thread Jim Nasby
On 4/4/15 8:38 AM, Chris Curvey wrote: On Fri, Apr 3, 2015 at 9:27 PM, Tom Lane t...@sss.pgh.pa.us mailto:t...@sss.pgh.pa.us wrote: Chris Curvey ch...@chriscurvey.com mailto:ch...@chriscurvey.com writes: Hmm, I'm trying to create a gin index, thusly: create index foo_idx on

Re: [GENERAL] could not split GIN page; no new items fit

2015-04-07 Thread Tom Lane
Jim Nasby jim.na...@bluetreble.com writes: On 4/4/15 8:38 AM, Chris Curvey wrote: I can! I just copied the data to a new table, obfuscated the sensitive parts, and was able to reproduce the error. I can supply the script to create and populate the table, but that's still clocking in at 250Mb

Re: [GENERAL] could not split GIN page; no new items fit

2015-04-07 Thread Jim Nasby
On 4/7/15 11:58 PM, Tom Lane wrote: Jim Nasby jim.na...@bluetreble.com writes: On 4/4/15 8:38 AM, Chris Curvey wrote: I can! I just copied the data to a new table, obfuscated the sensitive parts, and was able to reproduce the error. I can supply the script to create and populate the table,

Re: [GENERAL] could not split GIN page; no new items fit

2015-04-04 Thread Chris Curvey
On Fri, Apr 3, 2015 at 9:27 PM, Tom Lane t...@sss.pgh.pa.us wrote: Chris Curvey ch...@chriscurvey.com writes: Hmm, I'm trying to create a gin index, thusly: create index foo_idx on foo using gin(entry gin_trgm_ops); and I'm getting the error could not split GIN page; no new items fit

Re: [GENERAL] could not split GIN page; no new items fit

2015-04-03 Thread Tom Lane
Chris Curvey ch...@chriscurvey.com writes: Hmm, I'm trying to create a gin index, thusly: create index foo_idx on foo using gin(entry gin_trgm_ops); and I'm getting the error could not split GIN page; no new items fit Any idea what this means, or how I can get around it? Looks to me like a

[GENERAL] could not split GIN page; no new items fit

2015-04-03 Thread Chris Curvey
Hmm, I'm trying to create a gin index, thusly: create index foo_idx on foo using gin(entry gin_trgm_ops); and I'm getting the error could not split GIN page; no new items fit Any idea what this means, or how I can get around it? The table in question has about 23MM rows, if that makes any