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.


type: article, format: blog


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, 2 dimes, 1 penny + 100

Trackback URL