Re: Postgres NoSQL emulation

Поиск
Список
Период
Сортировка
От Pierre C
Тема Re: Postgres NoSQL emulation
Дата
Msg-id op.vvbdiwdceorkce@apollo13
обсуждение исходный текст
Ответ на Re: Postgres NoSQL emulation  (Merlin Moncure <mmoncure@gmail.com>)
Список pgsql-performance
> why even  have multiple rows? just jam it all it there! :-D

LOL

But seriously, when using an ORM to stuff an object hierarchy into a
database, you usually get problems with class inheritance, and all
solutions suck more or less (ie, you get a zillion tables, with assorted
pile of JOINs, or stinky key/attributes schemes where all attributes end
up as TEXT, or a table with 200 columns, most of them being NULL for a
given line).

NoSQL guys say "hey just use NoSQL !".

In a (common) case where the classes have some fields in common and othen
searched, and that the DB needs to know about and access easily, those
become columns, with indexes. Then the other fields which only occur in
some derived class and are not very interesting to the DB get shoved into
a hstore. The big bonus being that you use only one table, and the "extra"
fields can still be accessed and indexed (but a little slower than a
normal column). However I believe hstore can only store TEXT values...

Could be interesting. Or not.

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

Предыдущее
От: "Prodan, Andrei"
Дата:
Сообщение: 'Interesting' prepared statement slowdown on large table join
Следующее
От: Mason S
Дата:
Сообщение: Re: partition query on multiple cores