Re: "could not split GIN page; no new items fit" - Mailing list pgsql-general

From Jim Nasby
Subject Re: "could not split GIN page; no new items fit"
Date
Msg-id 5524B928.6020305@BlueTreble.com
Whole thread Raw
In response to Re: "could not split GIN page; no new items fit"  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On 4/7/15 11:58 PM, Tom Lane wrote:
> Jim Nasby <Jim.Nasby@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
>>> after being zipped. What's the best way of getting this data out to
>>> someone who can take a look at this?  (Feel free to contact me off-list
>>> to coordinate.)
>
>> It would be nice if you could further reduce it, but if not I'd suggest
>> posting it to something like DropBox and posting the public link here.
>
> So far I've been unable to reproduce the failure from Chris' data :-(
> Don't know why not.

Could it be dependent on the order of the data in the heap?

I'm assuming the field being indexed isn't one of the one's Chris had to
obfuscate...
--
Jim Nasby, Data Architect, Blue Treble Consulting
Data in Trouble? Get it in Treble! http://BlueTreble.com


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: "could not split GIN page; no new items fit"
Next
From: Björn Lundin
Date:
Subject: unexpected (to me) sorting order