Re: Hstore::TooBig ?

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