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

From Tom Lane
Subject Re: Indexing on JSONB field not working
Date
Msg-id 18649.1578002294@sss.pgh.pa.us
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>)
Re: Indexing on JSONB field not working  (Zhihong Zhang <zhihong@gmail.com>)
List pgsql-bugs
Zhihong Zhang <zhihong@gmail.com> writes:
> So I like to report 2 bugs,

> 1. “CREATE INDEX” with expression should generate stats automatically.

It does.

> 2. Auto-analyze should generate stats if it is not available, regardless of the number of records changed.

This doesn't square with anyone else's reality either.

You haven't given us one single bit of information about what you are
doing differently that might trigger such unexpected behavior.  But without
that, there's not much we can do to investigate this report.

            regards, tom lane



pgsql-bugs by date:

Previous
From: Zhihong Zhang
Date:
Subject: Re: Indexing on JSONB field not working
Next
From: Zhihong Zhang
Date:
Subject: Re: Indexing on JSONB field not working