Skip site navigation (1) Skip section navigation (2)

Re: best statistic target for boolean columns

From: Neil Conway <neilc(at)samurai(dot)com>
To: Gaetano Mendola <mendola(at)bigfoot(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-performance(at)postgresql(dot)org
Subject: Re: best statistic target for boolean columns
Date: 2004-09-27 23:43:45
Message-ID: 1096328625.25688.755.camel@localhost.localdomain (view raw or flat)
Thread:
Lists: pgsql-performance
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(at)postgresql(dot)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



In response to

Responses

pgsql-performance by date

Next:From: Gaetano MendolaDate: 2004-09-28 00:16:28
Subject: Re: best statistic target for boolean columns
Previous:From: Gaetano MendolaDate: 2004-09-27 22:42:06
Subject: Re: best statistic target for boolean columns

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group