Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Xnmhc-0000Tu-78 for pgsql-general@arkaria.postgresql.org; Mon, 10 Nov 2014 11:00:08 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1Xnmhb-0002rk-Jk for pgsql-general@arkaria.postgresql.org; Mon, 10 Nov 2014 11:00:07 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1Xnmha-0002qb-Cj for pgsql-general@postgresql.org; Mon, 10 Nov 2014 11:00:06 +0000 Received: from smtp5-g21.free.fr ([212.27.42.5]) by magus.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1XnmhS-0002KZ-D9 for pgsql-general@postgresql.org; Mon, 10 Nov 2014 11:00:05 +0000 Received: from erg (unknown [82.66.247.92]) by smtp5-g21.free.fr (Postfix) with ESMTPS id 22A58D480A6 for ; Mon, 10 Nov 2014 11:57:26 +0100 (CET) Date: Mon, 10 Nov 2014 12:00:45 +0100 From: Jehan-Guillaume de Rorthais To: pgsql-general@postgresql.org Subject: Re: Strange avg value size for index on expression in pg_stats Message-ID: <20141110120045.7cc7c976@erg> In-Reply-To: <20141110115254.2997aaf8@erg> References: <20141110115254.2997aaf8@erg> X-Mailer: Claws Mail 3.10.1 (GTK+ 2.24.24; x86_64-pc-linux-gnu) MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -2.6 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-general Precedence: bulk Sender: pgsql-general-owner@postgresql.org On Mon, 10 Nov 2014 11:52:54 +0100 Jehan-Guillaume de Rorthais wrote: > Hello, > > I'm not sure if I should post here or on pgsql-hackers. > > While investigating about a wrong result with my btree bloat estimation query, > I found a strange stat deviation between the average size of a value in its > table and its average size in one index on the "lower" expression. Oh, I forgot to add links to this query, for testing purpose: * https://gist.github.com/ioguix/c29d5790b8b93bf81c27 * explanations, see http://blog.ioguix.net/tag/bloat/ Cheers, -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general