Postgres Pro
Downloads
Home   >   mailing lists

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

From Robert Haas
Subject Re: FW: KVP table vs. hstore - hstore performance (Was: Postgres NoSQL emulation)
Date
Msg-id BANLkTikhV_Z0KJu54qNYsJE-9dVqbN4c8w@mail.gmail.com
Whole thread Raw
In response to FW: KVP table vs. hstore - hstore performance (Was: Postgres NoSQL emulation)  (<m1ott@hsr.ch>)
List pgsql-performance
Tree view 
On Tue, May 17, 2011 at 11:10 AM,  <m1ott@hsr.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

pgsql-performance by date:

Previous
From: Maciek Sakrejda
Date:
Subject: Re: SORT performance - slow?
Next
From: Robert Haas
Date:
Subject: Re: Pushing LIMIT into sub-queries of a UNION ALL