[PERFORM] Question about Generating Possible Plans by the planner/optimizer

2004-08-06 Thread sandra ruiz
in the docummentation about the planer it says: "It first combines all possible ways of scanning and joining the relations that appear in a query" I would like to know if there's a time limit to do that or if it just scans ALL the posibilities until it finishes..no matter the time it takes.. th

[PERFORM] hints in Postgres?

2003-12-11 Thread sandra ruiz
Hi list, I need to know if there is anything like hints of Oracle in Postgres..otherwise..I wish to find a way to force a query plan to use the indexes or tell the optimizer things like "optimize based in statistics", "I want to define the order of the a join" , "optimize based on a execution