Steve Nicolai wrote: > The software uses the like operator to select these related objects. > That gets slower as the number of objects increase, even though there > is an index on id.
See this page for how to create correct indexes for pattern matching operators: http://www.postgresql.org/docs/7.4/static/indexes-opclass.html -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---------------------------(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
