Hstore vs simple K:V
Hstore vs simple K:V
От:
A J <s5aly@yahoo.com>
Дата:
What are the key benefits of using hstore over simple K:V storage in Postgres where you split the key in its own column and value in its own column ?
Thank you for any inputs.
Re: Hstore vs simple K:V
От:
Richard Albright <ralbright@insiderscore.com>
Дата:
You don't need to do an entity attribute value model in a separate table to include mutliple key value pairs. since an hstore is schemaless, you can include them all in one column for a particular row.
On 06/06/2012 04:33 PM, A J wrote:
On 06/06/2012 04:33 PM, A J wrote:
What are the key benefits of using hstore over simple K:V storage in Postgres where you split the key in its own column and value in its own column ?
Thank you for any inputs.
--
Rick Albright
Senior Quantitative Analyst
Web: www.insiderscore.com
Email: ralbright@insiderscore.com
Rick Albright
Senior Quantitative Analyst
Web: www.insiderscore.com
Email: ralbright@insiderscore.com