Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

Re: [PERFORM] Releasing memory during External sorting?


  • From: Simon Riggs <simon(at)2ndquadrant(dot)com>
  • To: Ron Peacetree <rjpeace(at)earthlink(dot)net>
  • Cc: pgsql-hackers(at)postgresql(dot)org, pgsql-performance(at)postgresql(dot)org
  • Subject: Re: [PERFORM] Releasing memory during External sorting?
  • Date: Sun, 25 Sep 2005 18:45:30 +0100
  • Message-id: <1127670330(dot)19345(dot)84(dot)camel(at)localhost(dot)localdomain>

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





Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group