| 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: | 2005-09-25 17:45:30 |
| Message-ID: | 1127670330.19345.84.camel@localhost.localdomain |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Simon Riggs | 2005-09-25 18:31:36 | Re: [HACKERS] statement logging / extended query protocol issues |
| Previous Message | Simon Riggs | 2005-09-25 17:45:22 | Re: Releasing memory during External sorting? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Luke Lonergan | 2005-09-25 18:09:30 | Re: Advice on RAID card |
| Previous Message | Simon Riggs | 2005-09-25 17:45:22 | Re: Releasing memory during External sorting? |