Re: [HACKERS] self-tuning histograms

2002-05-30 Thread Tom Lane
Neil Conway <[EMAIL PROTECTED]> writes: > What does everyone think about adding self-tuning histograms > to PostgreSQL? > [ snip ] > I think that ST histograms would be useful because: > (1) It would make it easier for us to implement multi-dimensional > histograms (for more info, see the Abo

Re: [HACKERS] self-tuning histograms

2002-05-29 Thread Neil Conway
On Thu, 30 May 2002 13:52:08 +1000 (EST) "Gavin Sherry" <[EMAIL PROTECTED]> wrote: > On Wed, 29 May 2002, Neil Conway wrote: > > Histogram refinement can take place in two possible ways: online > > (as queries are executed, the histograms are updated immediately), > > or offline (the necessary dat

Re: [HACKERS] self-tuning histograms

2002-05-29 Thread Gavin Sherry
Neil, I've also been thinking about this but haven't had time to collect my thoughts. On Wed, 29 May 2002, Neil Conway wrote: > Histogram refinement can take place in two possible ways: online > (as queries are executed, the histograms are updated immediately), > or offline (the necessary data

[HACKERS] self-tuning histograms

2002-05-29 Thread Neil Conway
What does everyone think about adding self-tuning histograms to PostgreSQL? Briefly, a self-tuning histogram is one that is constructed without looking at the data in the attribute; it uses the information provided by the query executor to adjust a default set of histograms that are created when