Re: Terrible plan for join to nested union

Поиск
Список
Период
Сортировка
От Nate Allan
Тема Re: Terrible plan for join to nested union
Дата
Msg-id 9B2D6747F4AB8A47BE45216B06DEDAF92ABE66E3@PREXMB01.myfamily.int
обсуждение исходный текст
Ответ на Re: Terrible plan for join to nested union  (Pavel Stehule <pavel.stehule@gmail.com>)
Список pgsql-performance
>you are using EAV schema - it is against to relation model enough :)
>this schema has the most terrible performance for large datasets - looks on hstore instead

>Pavel

Actually despite the table named Attribute, I am not doing EAV though I can see why you'd think that.  Attributes are
partof the conceptual domain I'm modeling and I assure you there are first class columns in the schema for everything.
Regardless,that has nothing to do with my performance problem with joining to a nested union.
 

-Nate



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

Предыдущее
От: Pavel Stehule
Дата:
Сообщение: Re: Terrible plan for join to nested union
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Terrible plan for join to nested union