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
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
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
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)"
> "
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