Hstore VS. JSON

Поиск
Список
Период
Сортировка
Искать
От
Niels Kristian Schjødt
Тема
Hstore VS. JSON
Дата
Msg-id
2BA3AA5A-A83A-4662-A850-4FA830C65A46@autouncle.com
Список
Дерево обсуждения
Hstore VS. JSON Niels Kristian Schjødt <nielskristian@autouncle.com>
Re: Hstore VS. JSON Andrew Dunstan <andrew@dunslane.net>
Re: Hstore VS. JSON Merlin Moncure <mmoncure@gmail.com>
Hi,

I'm in the process of implementing a table for storing some raw data in the format of a hash containing one level of keys and values. The hash can be quite big (up to 50 keys pointing at values varying from one to several hundred characters)

Now, I'm in doubt whether to use JSON or Hstore for this task. Here is the facts:

- I'm not going to search a lot (if any) in the data stored in the column, i'm only going to load it out.
- The data is going to be heavily updated (not only inserted). Keys and values are going to be added/overwritten quite some times.
- My database's biggest current issue is updates, so i don't want that to be a bottle neck.
- I'm on postgresql 9.2 

So, question is: Which will be better performance wise, especially for updates? Does the same issues with updates on the MVCC structure apply to updates in Hstore? What is taking up most space on the HDD?
В списке pgsql-performance по дате отправления
От: Marc Mamin
Дата:
От: Andrew Dunstan
Дата:
Сообщение: Re: Hstore VS. JSON
FAQ