bookmark

Action executed in 0.000
●●●●●○○○

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

Comments

none yet

Post a Comment

* indicates a required field
anonymous (If you want to identify yourself, please sign in first.)
required This field is required.

Max size is 2 MB, aspect ratio 3:4 width:height
required This field is required.
Please include a short description.
required This field is required.

480 characters remaining.
is public

(Use this field if you have to. 3000 characters remaining.)
2 quarters, 1 nickel, 1 penny + 100

Trackback URL

http://derocher.org/~brian//trackback.php?ParentId=103975

form