Re: [HACKERS] Re: Top N queries and disbursion

[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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026