Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125])
	by mail.postgresql.org (Postfix) with ESMTP id AD3F5194E782
	for <pgsql-admin@postgresql.org>; Wed,  6 Jun 2012 17:33:52 -0300 (ADT)
Received: from nm34-vm6.bullet.mail.bf1.yahoo.com ([72.30.239.78])
	by makus.postgresql.org with smtp (Exim 4.72)
	(envelope-from <s5aly@yahoo.com>) id 1ScMvP-0002n2-Pf
	for pgsql-admin@postgresql.org; Wed, 06 Jun 2012 20:33:52 +0000
Received: from [98.139.212.146] by nm34.bullet.mail.bf1.yahoo.com with NNFMP;
	06 Jun 2012 20:33:38 -0000
Received: from [98.139.212.216] by tm3.bullet.mail.bf1.yahoo.com with NNFMP;
	06 Jun 2012 20:33:38 -0000
Received: from [127.0.0.1] by omp1025.mail.bf1.yahoo.com with NNFMP;
	06 Jun 2012 20:33:38 -0000
X-Yahoo-Newman-Property: ymail-3
X-Yahoo-Newman-Id: 390238.73445.bm@omp1025.mail.bf1.yahoo.com
Received: (qmail 76467 invoked by uid 60001); 6 Jun 2012 20:33:38 -0000
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024;
	t=1339014818; bh=ggzq9eCjXKteUSINojdPOHVhmYMlk8ItXU+e65zLxcQ=;
	h=X-YMail-OSG:Received:X-Mailer:Message-ID:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type;
	b=hI2I3FBwq/GDh/eYpZSlrombbri8REEB1Vjwsof46bSBSORpqTtrwbH4mG7wuhwakF9utmsOb1Zn0ubsHXEUkIoAa0zBO1VkiuuvA7AcWyp+Q7wem28dt6ZLaa1O/nbATQbUuwg/Uid3Lr3BOTr9BnTYrfathY/rsDH3y5HvqsY=
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=X-YMail-OSG:Received:X-Mailer:Message-ID:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type;
	b=haN/l7OTS/6unwPE/jiGM8hXylRkdqmQ9iJP4vK7Dx8gGo4GG3fjo7Fzacp2mi8BxtAggFrEyMZIoqoaul0xJQ8ok1xMv9tMhB7gzU+Uc4J+1ewZkrZf+WsA/k99BZ8v+UimrGVTHUILZub+WbyVB2ziuGi0vj+ecpA/JeLkjgs=;
X-YMail-OSG: j79tIowVM1lS4zlgecUqEqwaUkBvbwUSyPOpTAvpJNow9T4
	R0hwhU5R1g_Mbv.k0FCGxIzRPfOFOgpHYCmQFMFXEJlIoykbZQm7jsFX4RVx
	4FA9nIDitCbHBHDEAWoZYtQ7jFUksEbb7TxOOD9vHMYCdVBSvgT7q9dQBGzt
	fdD_CSieLg8Wkl2X6Fn_SxxGMwVb48CujEY_g5Xbx5vl04nWdecV1K3Tt6Vt
	39YQJ6Wv3kRVg_gdnRoNUMe34tp8I0cZR80L_N9EjxccXfoxYdAEHLH.AzxK
	3IVP9e375HKvhqDiiB1226Hqg1V3LXAxOhkH87I7zsGkN4vwPgJ2rvb8t2kD
	kBe8YK5oST2LIwbjTArtPf7LEguk2WxaDnyIpEJRljs516lDqqU7FOXqJ.I2
	fUEIq2K9AVDBD
Received: from [64.61.91.74] by web161505.mail.bf1.yahoo.com via HTTP;
	Wed, 06 Jun 2012 13:33:38 PDT
X-Mailer: YahooMailWebService/0.8.118.349524
Message-ID: <1339014818.64273.YahooMailNeo@web161505.mail.bf1.yahoo.com>
Date: Wed, 6 Jun 2012 13:33:38 -0700 (PDT)
From: A J <s5aly@yahoo.com>
Reply-To: A J <s5aly@yahoo.com>
Subject: Hstore vs simple K:V
To: PG Admin <pgsql-admin@postgresql.org>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="1679980782-399550965-1339014818=:64273"
X-Pg-Spam-Score: 0.8 (/)
X-Archive-Number: 201206/17
X-Sequence-Number: 39608

--1679980782-399550965-1339014818=:64273
Content-Type: text/plain; charset=us-ascii

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.

--1679980782-399550965-1339014818=:64273
Content-Type: text/html; charset=us-ascii

<html><body><div style="color:#000; background-color:#fff; font-family:times new roman, new york, times, serif;font-size:12pt"><div>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 ?</div><div><br>Thank you for any inputs.<br></div></div></body></html>
--1679980782-399550965-1339014818=:64273--