Re: Releasing memory during External sorting?

Поиск
Список
Период
Сортировка
От Simon Riggs
Тема Re: Releasing memory during External sorting?
Дата
Msg-id 1127670330.19345.84.camel@localhost.localdomain
обсуждение исходный текст
Ответ на Re: Releasing memory during External sorting?  (Ron Peacetree <rjpeace@earthlink.net>)
Список pgsql-performance
On Fri, 2005-09-23 at 12:48 -0400, Ron Peacetree wrote:

> > I have some indications from private tests that very high memory settings
> >may actually hinder performance of the sorts, though I cannot explain that
> >and wonder whether it is the performance tests themselves that have issues.
> >
> Hmmm.  Are you talking about amounts so high that you are throwing the OS
> into paging and swapping thrash behavior?  If not, then the above is weird.

Thanks for your thoughts. I'll retest, on the assumption that there is a
benefit, but there's something wrong with my earlier tests.

Best Regards, Simon Riggs



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

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: [HACKERS] Releasing memory during External sorting?
Следующее
От: "Ahmad Fajar"
Дата:
Сообщение: Re: tsearch2 seem very slow