tags: index

Action executed in 0.000

Each Tag


Common tags - number of posts

regex (2), PostgreSQL (2), ack (1), trigram (1), code (1), search (1), string (1), Po (1),

2 way join

PostgreSQL, index, index, regex

3 way join

PostgreSQL, index, regex


More tools for searching source code

tags: index, search, code, ack

A list of tools like ack and indexing tools like ctags.

url: http://beyondgrep.com/more-tools/

type: none, format: page


Fuzzy string matching with Trigram and Trigraphs - Postgres OnLine Journal

tags: Po, trigram, index, string
PostgreSQL lightbulb logo

In an earlier article Where is Soundex and other Fuzzy string things we covered the PostgreSQL contrib module fuzzstrmatch which contains the very popular function soundex that is found in other popular relational databases. We also covered the more powerful levenshtein distance, metaphone and dmetaphone functions included in fuzzstrmatch, but rarely found in other relational databases.

url: http://www.postgresonline.com/journal/archives/169-Fuzzy-string-matching-with-Trigram-and-Trigraphs.html

type: article, format: blog


select * from depesz; » Blog Archive » speeding up like ‘%xxx%’

DSHL logo

as most of you know postgresql can easily speedup searches using:

general idea is to use some kind of full text search/indexing – tsearch, lucene, sphinx, you name it.

but sometimes you can’t install fts/fti, or it doesn’t really solve your problem. is there any help? let’s find out.

url: http://www.depesz.com/index.php/2007/09/15/speeding-up-like-xxx/

type: article, format: blog


select * from depesz; » Blog Archive » indexable ” field like ‘%something’”

DSHL logo

for the long time everybody knew that you can’t use index on “LIKE” operations.

then came text_pattern_ops, so we could use indexes for prefix searches:

but what if i’d like to search for ‘%something’? not prefix, but suffix. in my example – what can i do to use indexes when searching for people from given domain?

url: http://www.depesz.com/index.php/2007/07/30/indexable-field-like-something/

type: article, format: blog