postgres optimizer

From: "Hossein S(dot) Attar" <mhsheikh(at)softbase(dot)math(dot)uwaterloo(dot)ca>
To: pgsql-general(at)postgresql(dot)org
Subject: postgres optimizer
Date: 2005-08-25 21:03:51
Message-ID: 430E3237.1080406@db.uwaterloo.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi:
I am working on postgres optimizer code to add some statistics
collection features for an academic project. At some point in my work, I
need to be able to tell if a join is a foreign key join or not. Also in
case of a foreign key join, I need to identify which input to the join
operator has the primary key attribute and which one has teh foreign
key. In other words, when we are making a JoinPath struct, I need to
identify if the join between the inner and outer RelOptInfo structs is a
foreign key join and if so, which RelOptInfo has the primary key. Does
anyone know the best way to do this? Should I go to "joinrestrictinfo"
field and go over all expressions? Is there any easier way?

Regards,
HSA

Responses

Browse pgsql-general by date

  From Date Subject
Next Message William Yu 2005-08-25 21:13:14 Re: Postgresql replication
Previous Message Matt A. 2005-08-25 20:44:52 help