On 06/24/2014 10:15 PM, CS_DBA wrote:
> I added a PK constraint on the id column and created this json index:
>
> create index mytest_json_col_idx on mytest ((task->'name'));
>
> However the planner never uses the index...
>
>
> EXPLAIN SELECT (mytest.task->>'name') as name,
>
> COUNT((mytest.
On Tue, Jun 24, 2014 at 3:15 PM, CS_DBA wrote:
> Hi All;
>
> We're struggling to get the planner to use a json index.
>
> I have this table :
>
> Table "public.mytest"
>
> Column | Type| Modifiers
>
> +---+---
Hi All;
We're struggling to get the planner to use a json index.
I have this table :
Table "public.mytest"
Column | Type| Modifiers
+---+-
id | bigint| no
