Search Postgresql Archives

Re: "could not split GIN page; no new items fit"

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 4/7/15 11:58 PM, Tom Lane wrote:
Jim Nasby <Jim.Nasby@xxxxxxxxxxxxxx> 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


--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux