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