Re: 2GB or not 2GB

Поиск
Список
Период
Сортировка
От Simon Riggs
Тема Re: 2GB or not 2GB
Дата
Msg-id 1212219897.4120.195.camel@ebony.site
обсуждение исходный текст
Ответ на 2GB or not 2GB  (Josh Berkus <josh@agliodbs.com>)
Ответы Re: 2GB or not 2GB  (Josh Berkus <josh@agliodbs.com>)
Список pgsql-performance
On Wed, 2008-05-28 at 16:59 -0700, Josh Berkus wrote:

> sort_mem: My tests with 8.2 and DBT3 seemed to show that, due to
> limitations of our tape sort algorithm, allocating over 2GB for a single
> sort had no benefit.  However, Magnus and others have claimed otherwise.
> Has this improved in 8.3?

There is an optimum for each specific sort.

Your results cannot be used to make a global recommendation about the
setting of work_mem. So not finding any benefit in your tests *and*
Magnus seeing an improvement are not inconsistent events.

--
 Simon Riggs           www.2ndQuadrant.com
 PostgreSQL Training, Services and Support


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

Предыдущее
От: Vlad Arkhipov
Дата:
Сообщение: Statistics issue
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Statistics issue