On Mon, Sep 19, 2016 at 02:10:50PM +0200, Kiran wrote:

> EXPLAIN ANALYZE select * from question where weighted_tsv @@
> to_tsquery('Hur&ofta');
> 
> I get the following output
> 
> "Bitmap Heap Scan on question  (cost=12.33..25.38 rows=10 width=731)
> (actual time=0.058..0.062 rows=3 loops=1)"
> "  Recheck Cond: (weighted_tsv @@ to_tsquery('Hur&ofta'::text))"
> "  Heap Blocks: exact=3"
> "  ->  Bitmap Index Scan on weighted_tsv_question_idx  (cost=0.00..12.33
> rows=10 width=0) (actual time=0.052..0.052 rows=3 loops=1)"
> "        Index Cond: (weighted_tsv @@ to_tsquery('Hur&ofta'::text))"
> "Planning time: 0.205 ms"
> "Execution time: 0.104 ms"
> 
> Why the query is using the Bitmap ? Not the Index scan ?

You want PostgreSQL to use an index to try speed up a query
which takes 0.3 milliseconds to select 3 out of 10 rows ?

What is your exact workload that requires speedup of that
query ?

Karsten
-- 
GPG key ID E4071346 @ eu.pool.sks-keyservers.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to