Home > mailing lists

Re: Postgres as key/value store - Mailing list pgsql-general

From	Thomas Kellerer
Subject	Re: Postgres as key/value store
Date	September 28, 2014 11:45:25
Msg-id	m08hqf$bg4$1@ger.gmane.org Whole thread Raw
In response to	Postgres as key/value store (snacktime <snacktime@gmail.com>)
List	pgsql-general

Tree view

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

pgsql-general by date:

From: Gavin Flower
Date: 28 September 2014, 03:34:19
Subject: Re: Postgres as key/value store

From: Mehdi Ravanbakhsh
Date: 28 September 2014, 15:19:15
Subject: call pl/pgsql function from main pl/pgsql function

Re: Postgres as key/value store - Mailing list pgsql-general

Previous

Next