Re: Working with huge amount of data. RESULTS!

Mario Lopez wrote:

> The problem is still with the LIKE '%keyword%', my problem is that I am  
> not searching for Words in a dictionary fashion, suppose my "data" is  
> random garbage, that it has common consecutive bytes. How could I  
> generate a dictionary from this random garbage to make it easier for  
> indexing?

Using trigrams perhaps?  Try checking whether pg_trgm fits your needs.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.