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

From: Stefan Keller <sfkeller(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: KVP table vs. hstore - hstore performance (Was: Postgres NoSQL emulation)
Date: 2011-05-14 10:10:32
Message-ID: BANLkTi=LjFTnn8hLwBZc1c87Vq+pw02+jQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hi,

I am conducting a benchmark to compare KVP table vs. hstore and got
bad hstore performance results when the no. of records is greater than
about 500'000.

CREATE TABLE kvp ( id SERIAL PRIMARY KEY, key text NOT NULL, value text );
-- with index on key
CREATE TABLE myhstore ( id SERIAL PRIMARY KEY, obj hstore NOT NULL );
-- with GIST index on obj

Does anyone have experience with that?

Yours, Stefan

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message ktm@rice.edu 2011-05-14 17:07:02 Re: Using pgiosim realistically
Previous Message Robert Haas 2011-05-14 02:28:51 Re: Query improvement