Re: Question about memory allocations - Mailing list pgsql-performance

From Andrew McMillan
Subject Re: Question about memory allocations
Date
Msg-id 1176453355.609.4.camel@hippy.mcmillan.net.nz
Whole thread Raw
In response to Question about memory allocations  (Steve <cheetah@tanabi.org>)
Responses Re: Question about memory allocations  (Steve <cheetah@tanabi.org>)
List 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.
-------------------------------------------------------------------------


Attachment

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Strangely Variable Query Performance
Next
From: "Avdhoot Kishore Saple"
Date:
Subject: local selectivity estimation - computing frequency of predicates