Re: PostgreSQL as a triple store

Поиск
Список
Период
Сортировка
От Chris Travers
Тема Re: PostgreSQL as a triple store
Дата
Msg-id CAKt_Zfsa+NrGNfHa0XxS62=yN3zLhrZMt9vLAqJZk=RhC-0nRg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: PostgreSQL as a triple store  (Seref Arikan <serefarikan@gmail.com>)
Список pgsql-general



On Wed, Aug 13, 2014 at 12:43 AM, Seref Arikan <serefarikan@gmail.com> wrote:
Hi Jimmy,
I think you're going to need to perform experiments and decide if the flexibility you get is worth the performance you're going to lose.
As you can see from John R Pierce's response it is only matter of time before someone (correctly) warns you about the performance issues with EAV derivatives, but then the conversation becomes too abstract, at least in my opinion.
Why? Because we don't know how much data you're going to process with this design, with what kind of hardware.

We also don't know how the data will be processed.

Where EAV dies a screaming horrible death is when you try to search on multiple attributes.  If this data is just never going to be searched on attributes, EAV isn't that bad (I use it for some things where that is clearly the case). 
 
--
Best Wishes,
Chris Travers

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

Предыдущее
От: pinker
Дата:
Сообщение: Re: Database block lifecycle
Следующее
От: M Tarkeshwar Rao
Дата:
Сообщение: Can I see the detailed log of query fired by particular Postgres client on Postgres server?