psql with ts_vector :: Remember, remember, the velvet November


node:	psql with ts_vector
template:	3
parent:	search engines
owner:	drakh
viewed by:
created:	18.04.2016 - 16:35:18
updated:	18.04.2016 - 17:24:03

cwbe coordinatez:
101
63533
8106902
8207635
8106913
8134046

ABSOLUT
KYBERIA

permissions
you:	r,
system:	public
net:	yes

Rychly hint ako na to cisto s PostgreSQL:
http://rachbelaid.com/postgres-full-text-search-is-good-enough/

00000101000635330810690208207635081069130813404608135368

btw, sphinx si neriesil niekedy? my sme to mali nabindovane v psql databazke na 100gb tabulke, a ficalo to nenormalne rychlo. aj wildcard vyrazy brutalita

00000101000635330810690208207635081069130813404608134079

toto je len psql ficuria ci vseobecne sql?

a btw, daju sa tam robit aj fuzzy queries s relaxaciou?

0000010100063533081069020820763508106913081340460813407908134086

mysql ma svoj vlastny nativny FT tiez, ale to je MyISAM only, a na texty by som ho asi moc nepouzival, ja som cez ten MyISAM fulltext riesil kybca like vektor rychly selekt z databazy (bolo to radovo rychlejsie ako cez LIKE)

0000010100063533081069020820763508106913081340460813407908134082

zmenil som zahlavie, tam je pekny clanok kde je to rychlo zhrnute

0000010100063533081069020820763508106913081340460813407908134080

len psql ficura