Re: Indexing on JSONB field not working

From: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
To: Zhihong Zhang <zhihong(at)gmail(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>, pgsql-bugs <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: Indexing on JSONB field not working
Date: 2019-12-29 16:11:39
Message-ID: CAMkU=1waicvb_FODcbJeZ8sO4EqTu7wZX4rQKu88AKxoCy97Zw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Sat, Dec 28, 2019 at 2:59 PM Zhihong Zhang <zhihong(at)gmail(dot)com> wrote:

Now we have stats, can anyone see why the index is not used?
>

You will have to redo the EXPLAIN (ANALYZE, BUFFERS) now that you
have stats, under both settings of enable_seqscan, and show us those.

Cheers,

Jeff

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Jeff Janes 2019-12-29 21:17:14 Re: BUG #16098: unexplained autovacuum to prevent wraparound
Previous Message Robert Haas 2019-12-29 12:37:15 Re: Assert failure due to "drop schema pg_temp_3 cascade" for temporary tables and \d+ is not showing any info after drooping temp table schema