From: | Andrew McMillan <andrew(at)catalyst(dot)net(dot)nz> |
---|---|
To: | Steve <cheetah(at)tanabi(dot)org> |
Cc: | pgsql-performance(at)postgresql(dot)org |
Subject: | Re: Question about memory allocations |
Date: | 2007-04-13 08:35:55 |
Message-ID: | 1176453355.609.4.camel@hippy.mcmillan.net.nz |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
On Tue, 2007-04-10 at 15:28 -0400, Steve wrote:
>
> I'm trying to tune the memory usage of a new machine that has a -lot- of
> memory in it (32 gigs).
...
>
> shared_buffers = 16GB
Really?
Wow!
Common wisdom in the past has been that values above a couple of hundred
MB will degrade performance. Have you done any benchmarks on 8.2.x that
show that you get an improvement from this, or did you just take the
"too much of a good thing is wonderful" approach?
Cheers,
Andrew.
-------------------------------------------------------------------------
Andrew @ Catalyst .Net .NZ Ltd, PO Box 11-053, Manners St, Wellington
WEB: http://catalyst.net.nz/ PHYS: Level 2, 150-154 Willis St
DDI: +64(4)803-2201 MOB: +64(272)DEBIAN OFFICE: +64(4)499-2267
You have an unusual equipment for success. Be sure to use it properly.
-------------------------------------------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Avdhoot Kishore Saple | 2007-04-13 08:59:30 | local selectivity estimation - computing frequency of predicates |
Previous Message | Tom Lane | 2007-04-13 04:38:11 | Re: Strangely Variable Query Performance |