Re: postgres optimizer - Mailing list pgsql-general

From Hossein S. Attar
Subject Re: postgres optimizer
Date
Msg-id 43147BFB.2070401@db.uwaterloo.ca
Whole thread Raw
In response to Re: postgres optimizer  ("Joshua D. Drake" <jd@commandprompt.com>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: or kills performance
Next
From: Tom Lane
Date:
Subject: Re: detection of VACUUM in progress