Re: [GENERAL] Index scan is not working

2016-09-19 Thread Jeff Janes
On Mon, Sep 19, 2016 at 5:10 AM, Kiran wrote: > Dear All, > > I have a table called question which has a ts_vector column *weighted_tsv* > . > I have gin indexed the weighted_tsv column. > > When I query using the following > > EXPLAIN ANALYZE select * from question

Re: [GENERAL] Index scan is not working

2016-09-19 Thread Karsten Hilbert
On Mon, Sep 19, 2016 at 02:56:17PM +0200, Kiran wrote: > I want to know whatever the Analyze output I am getting is normal for a > table having few records or something is wrong. > Will the DB engine uses whatever the best way to execute a query > irrespective of the indexing in this case? It

Re: [GENERAL] Index scan is not working

2016-09-19 Thread Kiran
Hi Karsten, Thanks for the response. I want to know whatever the Analyze output I am getting is normal for a table having few records or something is wrong. Will the DB engine uses whatever the best way to execute a query irrespective of the indexing in this case? At the moment the records in

Re: [GENERAL] Index scan is not working

2016-09-19 Thread Karsten Hilbert
On Mon, Sep 19, 2016 at 02:10:50PM +0200, Kiran wrote: > EXPLAIN ANALYZE select * from question where weighted_tsv @@ > to_tsquery('Hur'); > > 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)" > "

[GENERAL] Index scan is not working

2016-09-19 Thread Kiran
Dear All, I have a table called question which has a ts_vector column *weighted_tsv*. I have gin indexed the weighted_tsv column. When I query using the following EXPLAIN ANALYZE select * from question where weighted_tsv @@ to_tsquery('Hur'); I get the following output "Bitmap Heap Scan on