Re: Releasing memory during External sorting? - Mailing list pgsql-performance

From Simon Riggs
Subject Re: Releasing memory during External sorting?
Date
Msg-id 1127670330.19345.84.camel@localhost.localdomain
Whole thread Raw
In response to Re: Releasing memory during External sorting?  (Ron Peacetree <rjpeace@earthlink.net>)
List 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 by date:

Previous
From: Simon Riggs
Date:
Subject: Re: [HACKERS] Releasing memory during External sorting?
Next
From: "Ahmad Fajar"
Date:
Subject: Re: tsearch2 seem very slow