Configurei o stopwords, o ispell o stem. Shairon wrote: > > Como está sua solução? Vc configurou stopwords da linguagem? > > 2009/5/6 charles andre <[email protected]> > >> >> Foi isso que fiz e ficou lento. >> >> >> Shairon wrote: >> > >> > criar uma coluna tsvector e indexa-la usando gist, depois vacuum >> > full/analyze; reindex table foo >> > >> > >> > 2009/5/6 charles andre <[email protected]> >> > >> >> >> >> Tenho que fazer uma pesquisa por nome em uma tabela de 200 milhoes de >> >> registros. Testei o Tserach, e qdo o nome esta no final da tabela esta >> >> demorando muito. >> >> >> >> Alguem tem alguma sugestão ou ha algum modo melhor de fazer isso ? >> >> -- >> >> View this message in context: >> >> >> http://www.nabble.com/Pesquisa-por-nome-Tsearch-tp23410634p23410634.html >> >> Sent from the PostgreSQL - Brasil mailing list archive at Nabble.com. >> >> >> >> _______________________________________________ >> >> pgbr-geral mailing list >> >> [email protected] >> >> https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral >> >> >> > >> > >> > >> > -- >> > [ ]'s >> > Shairon Toledo >> > http://www.hashcode.eti.br >> > >> > _______________________________________________ >> > pgbr-geral mailing list >> > [email protected] >> > https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral >> > >> > >> >> -- >> View this message in context: >> http://www.nabble.com/Pesquisa-por-nome-Tsearch-tp23410634p23414104.html >> Sent from the PostgreSQL - Brasil mailing list archive at Nabble.com. >> >> _______________________________________________ >> pgbr-geral mailing list >> [email protected] >> https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral >> > > > > -- > [ ]'s > Shairon Toledo > http://www.hashcode.eti.br > > _______________________________________________ > pgbr-geral mailing list > [email protected] > https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral > >
-- View this message in context: http://www.nabble.com/Pesquisa-por-nome-Tsearch-tp23410634p23415367.html Sent from the PostgreSQL - Brasil mailing list archive at Nabble.com. _______________________________________________ pgbr-geral mailing list [email protected] https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
