Re: disbursion again

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: PostgreSQL-development <pgsql-hackers(at)postgreSQL(dot)org>
Subject: Re: disbursion again
Date: 2000-06-02 00:52:35
Message-ID: 8744.959907155@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> Also, Tom, should we preload the disbursion buckets with most common
> value from the previous run on the assumption we will get a better
> value?

Hmm, I don't see why that'd make it better. It'd probably bias us
in favor of continuing to report the same value from run to run,
which might have some benefit. The thing is that if no value in
the table is especially common, the existing algorithm will give a
nearly random selection that might not be the most common value or
even very close to it.

I'm not really excited about spending effort on marginal tweaks
of the current method, however. What we really need is more stats
(and more reliable stats) than we have, and that's going to require
some work.

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Jorge Alvarez 2000-06-02 01:19:33 Pg_Dump strange error
Previous Message Tom Lane 2000-06-02 00:43:35 Re: config files in /data