Re:Full text search in milliseconds with PostgreSQL
by alexhill on Friday May 08, 2015 @11:38PM
(#9515396)
If you want to preprocess your document, or aggregate different parts of it with different labels and weights, it can be helpful to store it in a separate column.
Of course you can always just index your preprocessing/aggregating function and call it every time you want to search, but depending on how expensive that is, it might be in your interest to do it upfront and make your searches a bit quicker.
Of course you can always just index your preprocessing/aggregating function and call it every time you want to search, but depending on how expensive that is, it might be in your interest to do it upfront and make your searches a bit quicker.