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
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
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,
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
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
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