X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id CCB53329E7B for ; Tue, 28 Sep 2004 00:44:18 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 90120-01 for ; Mon, 27 Sep 2004 23:44:11 +0000 (GMT) Received: from sue.samurai.com (sue.samurai.com [205.207.28.74]) by svr1.postgresql.org (Postfix) with ESMTP id 016CE32A025 for ; Tue, 28 Sep 2004 00:44:11 +0100 (BST) Received: from localhost (localhost [127.0.0.1]) by sue.samurai.com (Postfix) with ESMTP id 28AF63ED7; Mon, 27 Sep 2004 19:44:11 -0400 (EDT) Received: from sue.samurai.com ([127.0.0.1]) by localhost (sue.samurai.com [127.0.0.1]) (amavisd-new, port 10024) with LMTP id 19635-01-6; Mon, 27 Sep 2004 19:44:10 -0400 (EDT) Received: from localhost (unknown [61.88.101.19]) by sue.samurai.com (Postfix) with ESMTP id 47BBB3ECD; Mon, 27 Sep 2004 19:44:09 -0400 (EDT) Subject: Re: best statistic target for boolean columns From: Neil Conway To: Gaetano Mendola Cc: Tom Lane , pgsql-performance@postgresql.org In-Reply-To: <4158973E.7010408@bigfoot.com> References: <87k6uf7ceu.fsf@stark.xeocode.com> <3481.1096313192@sss.pgh.pa.us> <4158973E.7010408@bigfoot.com> Content-Type: text/plain Message-Id: <1096328625.25688.755.camel@localhost.localdomain> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 Date: Tue, 28 Sep 2004 09:43:45 +1000 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at mailbox.samurai.com X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200409/302 X-Sequence-Number: 8430 On Tue, 2004-09-28 at 08:42, Gaetano Mendola wrote: > Now I'm reading an article, written by the same author that ispired the magic "300" > on analyze.c, about "Self-tuning Histograms". If this is implemented, I understood > we can take rid of "vacuum analyze" for mantain up to date the statistics. > Have someone in his plans to implement it ? http://www.mail-archive.com/pgsql-hackers@postgresql.org/msg17477.html Tom's reply is salient. I still think self-tuning histograms would be worth looking at for the multi-dimensional case. -Neil