[Charset iso-8859-1 unsupported, filtering to ASCII...]
> Surely we could store more information (using vacuum) about each table, to
> be able to produce good stats relatively quickly? This would mean that the
> estimates would be dependent on vacuum, but there are worse options. Also,
> can't we do something similar to what Oracle does, where you can define your
> optimisation to be rule-based, or stats-based. If it's rule based, the
> optimizer looks only at the schema to decide how to optimize. If
> stats-based, then it has a huge amount of information at its disposal to
> determine how to optimise. However, those stats are compiled by something
> like vacuum.
Stats are compiled by vacuum analyze, and every column is analyzed the
same way.
-- Bruce Momjian | http://www.op.net/~candle maillist@candle.pha.pa.us | (610)
853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill,
Pennsylvania19026
