Tom Lane wrote: > Bruce Momjian <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend