Indexing the t_name.name field, I can increase speed, but only if I
restrict my search to something like :
select *
from t_name
where t_name.name like 'my_search%'
(In this case it takes generally less than 1 second)
My question : Are there algorithms or tools that can speed up such a
type of queries ("like" condition begining with a "%" symbol) ?
Apart from indexing the field you could use full text indexing. See
http://techdocs.postgresql.org/techdocs/fulltextindexing.php
What other types of queries are you running that you want to speed up ?
