Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1in8U8-00060v-Dz for pgsql-bugs@arkaria.postgresql.org; Thu, 02 Jan 2020 21:58:28 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1in8U5-0002W4-Q7 for pgsql-bugs@arkaria.postgresql.org; Thu, 02 Jan 2020 21:58:25 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1in8U5-0002VC-Hy for pgsql-bugs@lists.postgresql.org; Thu, 02 Jan 2020 21:58:25 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1in8Tx-0004bA-Je for pgsql-bugs@lists.postgresql.org; Thu, 02 Jan 2020 21:58:23 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.4/8.14.4) with ESMTP id 002LwEnc018650; Thu, 2 Jan 2020 16:58:14 -0500 From: Tom Lane To: Zhihong Zhang cc: Jeff Janes , Tomas Vondra , pgsql-bugs Subject: Re: Indexing on JSONB field not working In-reply-to: <39B1D245-31C9-407E-8136-514890B92CBA@gmail.com> References: <0cf001d5b77f$bfe47e10$3fad7a30$@gmail.com> <20191220223005.f6w4ff4kdbgtanpz@development> <20191221114003.yo56lv3o6thdvxtn@development> <21855.1576943356@sss.pgh.pa.us> <0AA828F3-5BA5-48CD-B229-8351ACB308D3@gmail.com> <167501d5bcdb$13854b20$3a8fe160$@gmail.com> <11610.1577468732@sss.pgh.pa.us> <202A204F-FE4D-414A-ABD0-B7773A0C7316@gmail.com> <39B1D245-31C9-407E-8136-514890B92CBA@gmail.com> Comments: In-reply-to Zhihong Zhang message dated "Thu, 02 Jan 2020 16:49:01 -0500" MIME-Version: 1.0 Content-Type: text/plain; charset="UTF-8" Content-ID: <18648.1578002294.1@sss.pgh.pa.us> Content-Transfer-Encoding: quoted-printable Date: Thu, 02 Jan 2020 16:58:14 -0500 Message-ID: <18649.1578002294@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Zhihong Zhang writes: > So I like to report 2 bugs, > 1. =E2=80=9CCREATE INDEX=E2=80=9D 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 withou= t that, there's not much we can do to investigate this report. regards, tom lane