Re: Hstore vs simple K:V - Mailing list pgsql-admin

From Richard Albright
Subject Re: Hstore vs simple K:V
Date
Msg-id 4FCFC5B6.1070300@insiderscore.com
Whole thread Raw
In response to Hstore vs simple K:V  (A J <s5aly@yahoo.com>)
List pgsql-admin
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:
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

pgsql-admin by date:

Previous
From: Amador Alvarez
Date:
Subject: Re: Can schemas be ordered regarding their creation time ?
Next
From: hari.fuchs@gmail.com
Date:
Subject: Re: Can schemas be ordered regarding their creation time ?