[Rt-devel] Searches on attachments.content using Oracle

[Alan Barrett]

On Sun, 22 Aug 2004, Joop van de Wege wrote:
> To put things into perspective:
> select * from attachments where contains(content, 'sendmail')>0 
> 12 rows in ~150msec, that is cached by the database, first time ~25sec.
> 
> select * from attachments where content like '%sendmail%'
> 12 rows in 2:23 first time, ~40 sec every next invocation.

That's impressive.  Does anybody have a similar optimisation for
postgresql?

--apb (Alan Barrett)