| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Zhihong Zhang <zhihong(at)gmail(dot)com> |
| Cc: | Jeff Janes <jeff(dot)janes(at)gmail(dot)com>, 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: | 2020-01-02 21:58:14 |
| Message-ID: | 18649.1578002294@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
Zhihong Zhang <zhihong(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Zhihong Zhang | 2020-01-02 22:07:28 | Re: Indexing on JSONB field not working |
| Previous Message | Zhihong Zhang | 2020-01-02 21:49:01 | Re: Indexing on JSONB field not working |