| From: | "Hossein S(dot) Attar" <mhsheikh(at)softbase(dot)math(dot)uwaterloo(dot)ca> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: postgres optimizer |
| Date: | 2005-08-30 15:32:11 |
| Message-ID: | 43147BFB.2070401@db.uwaterloo.ca |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
>
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bohdan Linda | 2005-08-30 15:35:13 | detection of VACUUM in progress |
| Previous Message | Tom Lane | 2005-08-30 15:26:30 | Re: or kills performance |