Re: Hstore::TooBig ?

From: john gale <john(at)smadness(dot)com>
To: Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Hstore::TooBig ?
Date: 2013-11-01 00:12:27
Message-ID: 984743FD-3FE1-4385-82F0-8E8A5C4AECDA@smadness.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On Oct 31, 2013, at 4:44 PM, Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> wrote:

>> So to piece out the questions,
>> - is there a total size limitation of the hstore field? or is it theoretically large enough (1GB) that it really shouldn't matter?
>> - is there a string size limitation of each key/val in 9.x, or is it still 65k from 8.x?
>> - is Hstore::TooBig an error that is likely coming from postgres? or should I continue poking at ActiveRecord or other places?
>
>
> Two things I can think of.
>
> 1) Grep the above gems for the Hstore::TooBig message
>
> 2) Ask on a Rails list, in light of your second post where you say the error does not touch the Postgres log. Would seem to indicate a Ruby/Rails issue.

These were done in parallel, which is why I was asking the question on a postgres list.

The further questions still apply though; are there documented size limitations for hstore?

~ john

In response to

Browse pgsql-general by date

  From Date Subject
Next Message John R Pierce 2013-11-01 01:04:03 Re: Hstore::TooBig ?
Previous Message john gale 2013-11-01 00:11:52 Re: Hstore::TooBig ?