From: Simon Riggs <simon@2ndquadrant.com>
To: Ron Peacetree <rjpeace@earthlink.net>
Cc: pgsql-hackers@postgresql.org
Cc: pgsql-performance@postgresql.org
Subject: Re: [PERFORM] Releasing memory during External sorting?
Date: Sun, 25 Sep 2005 18:45:30 +0100
Message-ID: <1127670330.19345.84.camel@localhost.localdomain> (raw)
In-Reply-To: <2559192.1127494115558.JavaMail.root@elwamui-huard.atl.sa.earthlink.net>
References: <2559192.1127494115558.JavaMail.root@elwamui-huard.atl.sa.earthlink.net>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: simon@2ndquadrant.com, rjpeace@earthlink.net, pgsql-hackers@postgresql.org
Subject: Re: [PERFORM] Releasing memory during External sorting?
In-Reply-To: <1127670330.19345.84.camel@localhost.localdomain>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox