Tom Lane wrote:
> Bruce Momjian <pgman@candle.pha.pa.us> writes:
> > Do all the columns have to have the same number of statistics buckets?
>
> They do not, but the effort spent by ANALYZE is proportional to the
> largest stats target among all the columns of the table.
Could we use previous stats to determine how many buckets to use when
running ANALYZE. Also, if columns have a different number of buckets,
does that mean that we don't have the same per-query overhead for a
larger stats target?
-- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610)
359-1001+ If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square,
Pennsylvania19073