Re: [GENERAL] postgres optimizer

2005-08-30 Thread Hossein S. Attar
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

[GENERAL] postgres optimizer

2005-08-26 Thread Hossein S. Attar
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