Oleg, > The output of the query should contain about 200 rows. So, I guess the > planer is off assuming that the query should return 1 row.
Oh, also did you post the query before? Can you re-post it with the planner results? -- Josh Berkus Aglio Database Solutions San Francisco ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match