Re: postgres optimizer

Поиск
Список
Период
Сортировка
От Hossein S. Attar
Тема Re: postgres optimizer
Дата
Msg-id 43147BFB.2070401@db.uwaterloo.ca
обсуждение исходный текст
Ответ на Re: postgres optimizer  ("Joshua D. Drake" <jd@commandprompt.com>)
Список pgsql-general
Like I said it's a research project. There is a feature that I'm trying
to add to optimizer, but this feature should only be used when a join is
a foreign key join.

Hossein


Joshua D. Drake wrote:

>
> I would be interested in knowing "why" you want to do such a thing? What
> is it you expect to gain?
>
> Sincerely,
>
> Joshua D. Drake
>
>>
>>
>> The planner doesn't think there is any such thing as a "foreign key
>> join".  Perhaps you should modify the foreign key triggers (in
>> ri_triggers.c) to collect the information you need.
>>
>>             regards, tom lane
>>
>> ---------------------------(end of broadcast)---------------------------
>> TIP 4: Have you searched our list archives?
>>
>>                http://archives.postgresql.org
>
>
>


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: or kills performance
Следующее
От: Tom Lane
Дата:
Сообщение: Re: detection of VACUUM in progress