Postgresql: trigram indexes for searching

When full text search is overkill and like queries do not deliver this might be an approach you could try...