View Single Post

   
  #2 (permalink)  
Old 04-11-2008, 07:53 AM
Tom Lane
 
Posts: n/a
Default Re: Optimizer bug in 8.1.0?

Alexey Slynko <slynko@tronet.ru> writes:
> Any suggestions?


Fix contrib/intarray to have some selectivity estimation procedures
for its operators?

Without any way to estimate the number of rows matching the @@
condition, the optimizer can hardly be expected to guess right...

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

Reply With Quote