On Jan 28, 2008 11:38 AM, A.Burbello <burbello3000@xxxxxxxxxxxx> wrote: > Hi people, > > I would like to some suggestion to search person name > in a table that has more than 150 milions of rows ... > > e.g ... name like 'JOHN%SMITH'; > > I know there is contrib Tsearch, but I can't for > political reasons. > Is there any way to do with good performance??? Would pointing out to the PHBs that tsearch was integrated into pgsql with v8.3 help convince them to stop being reactionary idiots? ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate