Re: Group-count estimation statistics

Поиск
Список
Период
Сортировка
От Kris Jurka
Тема Re: Group-count estimation statistics
Дата
Msg-id Pine.BSO.4.56.0501281628001.23832@leary.csoft.net
обсуждение исходный текст
Ответ на Re: Group-count estimation statistics  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Group-count estimation statistics
Список pgsql-hackers

On Fri, 28 Jan 2005, Tom Lane wrote:

> you don't GROUP BY unique combinations of columns over huge
> tables --- or at least, you shouldn't expect great performance if you do.

The proposed change biases towards a hash plan which has no provision for
spilling to disk.  Slow is one thing, but excessive memory usage and
possibly failing is another thing.

Kris Jurka


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

Предыдущее
От: Bruno Wolff III
Дата:
Сообщение: Re: Allow GRANT/REVOKE permissions to be applied to all schema objects with one command
Следующее
От: "Merlin Moncure"
Дата:
Сообщение: Re: Allow GRANT/REVOKE permissions to be applied to all schema objects with one command