Postgres Pro
Downloads
Home   >   mailing lists

Re: Indexing on JSONB field not working - Mailing list pgsql-bugs

From Jeff Janes
Subject Re: Indexing on JSONB field not working
Date
Msg-id CAMkU=1waicvb_FODcbJeZ8sO4EqTu7wZX4rQKu88AKxoCy97Zw@mail.gmail.com
Whole thread Raw
In response to Re: Indexing on JSONB field not working  (Zhihong Zhang <zhihong@gmail.com>)
Responses Re: Indexing on JSONB field not working  (Zhihong Zhang <zhihong@gmail.com>)
List pgsql-bugs
Tree view
On Sat, Dec 28, 2019 at 2:59 PM Zhihong Zhang <zhihong@gmail.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 

pgsql-bugs by date:

Previous
From: Zhihong Zhang
Date:
Subject: Re: Indexing on JSONB field not working
Next
From: Jeff Janes
Date:
Subject: Re: BUG #16098: unexplained autovacuum to prevent wraparound