Full text search
- Moving from storing the tsvector values to a tsvector index
- When tsvector was working as expected on most hosts, but not one
- to_tsquery gives ‘ERROR: syntax error in tsquery’ when it contains a space
- A PostgreSQL query runs in 1.7s – add a LIMIT 10, runs in 28.2 seconds
- Replacing a column search with a full text search solution