Thanks Jeff! That makes sense indeed.
I'm a bit surprised a COUNT(1) would need a bitmap heap scan since we know
the row count from the index, but okay.
Have a nice day,
Laurent
On Thu, Jul 23, 2015 at 8:04 PM, Jeff Janes wrote:
> On Thu, Jul 23, 2015 at 9:58 AM, Laurent Debacker
t; Bitmap Index Scan on enterprises_fts_idx (cost=0.00..4869.61
rows=541014 width=0) (actual time=120.214..120.214 rows=528376 loops=1)"
" Index Cond: (fts @@ '''activ'''::tsquery)"
" Buffers: shared hit=1 read=96"
"Planning time: 2.383 ms"
"Execution time: 25824.476 ms"
Any advice would be greatly appreciated. I'm running PostgreSQL 9.4.1.
Thank you,
Laurent Debacker
