On Wed, Aug 22, 2007 at 12:02:54PM -0400, Carlo Stonebanks wrote: > Any suggestions on where to go with this project to improve performance > would be greatly appreciated. I'm a bit unsure from reading your mail -- have you tried pg_trgm with a GiST index? /* Steinar */ -- Homepage: http://www.sesse.net/ ---------------------------(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