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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
