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

Поиск
Список
Период
Сортировка
От Stefan Keller
Тема KVP table vs. hstore - hstore performance (Was: Postgres NoSQL emulation)
Дата
Msg-id BANLkTi=LjFTnn8hLwBZc1c87Vq+pw02+jQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: KVP table vs. hstore - hstore performance (Was: Postgres NoSQL emulation)  (Craig Ringer <craig@postnewspapers.com.au>)
Re: KVP table vs. hstore - hstore performance (Was: Postgres NoSQL emulation)  (Merlin Moncure <mmoncure@gmail.com>)
Список 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

В списке pgsql-performance по дате отправления:

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: Query improvement
Следующее
От: "ktm@rice.edu"
Дата:
Сообщение: Re: Using pgiosim realistically