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@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