Re: Hstore::TooBig ? - Mailing list pgsql-general

From John R Pierce
Subject Re: Hstore::TooBig ?
Date
Msg-id 5272FE03.4000507@hogranch.com
Whole thread Raw
In response to Re: Hstore::TooBig ?  (john gale <jgale@apple.com>)
List pgsql-general
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



pgsql-general by date:

Previous
From: john gale
Date:
Subject: Re: Hstore::TooBig ?
Next
From: Dann Corbit
Date:
Subject: Re: postgresql-9.3.1-1-windows-x64.exe does not install correctly for me