Re: patch: SQL/MED(FDW) DDL

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
Cc: pgsql-hackers@postgresql.org
Date: 2010-09-16T02:05:00Z
Lists: pgsql-hackers
Mark Kirkwood <mark.kirkwood@catalyst.net.nz> writes:
> On 16/09/10 13:22, Tom Lane wrote:
>> What exactly do those get you that an ordinary index, or at worst an
>> index-organized table, doesn't get you?

> It is pretty rare to see key value stores vs relational engines 
> discussed without a descent into total foolishiness, but this Wikipedia 
> page looks like a reasonable summary:
> http://en.wikipedia.org/wiki/NoSQL

That doesn't do anything at all to answer my question.  I don't want
to debate NoSQL versus traditional RDBMS here.  What I asked was:
given that PG is a traditional RDBMS, what exactly are you hoping
to accomplish by putting a key-value storage mechanism in it?  And
if you did, how would that be different from an index-organized table?

			regards, tom lane