Re: [PERFORM] pg_trgm and slow bitmap index scan plan

2012-08-28 Thread Merlin Moncure
On Tue, Aug 28, 2012 at 2:39 AM, Mathieu De Zutter wrote: > Hi all, > > I've been trying to apply pg_tgrm for the search-function of my application. > The database fits a few times in the available RAM, and is mostly read-only. > Plans, schema and configs in attachment. Postgresql version 9.1.4 on

[PERFORM] pg_trgm and slow bitmap index scan plan

2012-08-28 Thread Mathieu De Zutter
Hi all, I've been trying to apply pg_tgrm for the search-function of my application. The database fits a few times in the available RAM, and is mostly read-only. Plans, schema and configs in attachment. Postgresql version 9.1.4 on Debian. When just searching in one table, it behaves perfectly her