Re: FW: KVP table vs. hstore - hstore performance (Was: Postgres NoSQL emulation)

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: m1ott(at)hsr(dot)ch
Cc: mmoncure(at)gmail(dot)com, sfkeller(at)gmail(dot)com, pgsql-performance(at)postgresql(dot)org
Subject: Re: FW: KVP table vs. hstore - hstore performance (Was: Postgres NoSQL emulation)
Date: 2011-05-23 17:19:48
Message-ID: BANLkTikhV_Z0KJu54qNYsJE-9dVqbN4c8w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Tue, May 17, 2011 at 11:10 AM, <m1ott(at)hsr(dot)ch> wrote:
> For Hstore I'm using a GIST index.

I would have thought that GIN would be a better choice for this workload.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Robert Haas 2011-05-23 17:21:17 Re: Pushing LIMIT into sub-queries of a UNION ALL
Previous Message Maciek Sakrejda 2011-05-23 17:01:42 Re: SORT performance - slow?