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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
