On Sat, May 14, 2011 at 5:10 AM, Stefan Keller <sfkeller@xxxxxxxxx> 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? hstore is not really designed for large-ish sets like that. merlin -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
