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

From: Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
To: Stefan Keller <sfkeller(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: KVP table vs. hstore - hstore performance (Was: Postgres NoSQL emulation)
Date: 2011-05-16 00:25:23
Message-ID: 4DD06EF3.7030003@postnewspapers.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On 14/05/11 18:10, Stefan Keller wrote:
> 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?

What are your queries?

What does EXPLAIN ANALYZE report on those queries?

Did you ANALYZE your tables after populating them?

--
Craig Ringer

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Craig Ringer 2011-05-16 01:05:25 Re: reducing random_page_cost from 4 to 2 to force index scan
Previous Message Dan Birken 2011-05-15 22:27:31 Re: slow loop inserts?