Re: Group-count estimation statistics

Поиск
Список
Период
Сортировка
От Stephen Frost
Тема Re: Group-count estimation statistics
Дата
Msg-id 20050128182540.GA10437@ns.snowman.net
обсуждение исходный текст
Ответ на Group-count estimation statistics  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
* Tom Lane (tgl@sss.pgh.pa.us) wrote:
> The only real solution, of course, is to acquire cross-column
> statistics, but I don't see that happening in the near future.

That'd be nice, but sounds like alot of work.

> As a short-term hack, I am thinking that the "clamp to size of table"
> part of the rule is overly pessimistic, and that we should consider
> something like "clamp to size of table / 10" instead.  The justification
> for this is the thought that you aren't going to bother grouping unless
> it actually reduces the data volume.  We have used similar rules in the

I definitely agree with this.
Stephen

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Re: [pgsql-hackers] Patent issues and 8.1
Следующее
От: Greg Stark
Дата:
Сообщение: Re: Group-count estimation statistics