On 10/31/2013 5:11 PM, john gale wrote:
The further questions still apply though; are there documented size limitations for hstore?
afaik only the practical limits of how big you want your tables to get, and the 1GB limit of the underlying text representation. having many 1000s of keys in a single hstore would likely make for some painful performance, and nasty memory requirements (returning all keynames, for instance, so you could enumerate them, ouch)
-- john r pierce 37N 122W somewhere on the middle of the left coast -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general