Re: Postgres as key/value store

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Postgres as key/value store
Date: 2014-09-28 08:44:56
Message-ID: m08hqf$bg4$1@ger.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

snacktime wrote on 28.09.2014 01:48:
> I'm looking for some feedback on the design I'm using for a basic key/value storage using postgres.

Are you aware of Postgres' "native" key/value store: hstore?
http://www.postgresql.org/docs/current/static/hstore.html

Or Postgres JSON support?

Especially the new JSONB in the upcoming 9.4 release which makes indexing JSON documents much eaasier/faster.

I would expect both solutions to be much faster than your entity-attribute-value design.

Thomas

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Mehdi Ravanbakhsh 2014-09-28 12:19:03 call pl/pgsql function from main pl/pgsql function
Previous Message Gavin Flower 2014-09-28 00:33:53 Re: Postgres as key/value store