On 07/26/2012 12:26 PM, Betz, Gregory wrote: > It looks as though the content within ticket is indexed based off of > whitespaces into the attachments table.
It's not necessarily just whitespace, but it's however Pg internally tokenizes the text. substring matching on tokens is a hard problem to get right without bogging down to the same problems as LIKE. If you search around there's a lot of discussion about this, as Ken suggests.
