pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Andrew McMillan <andrew@catalyst.net.nz>
To: Steve <cheetah@tanabi.org>
Cc: pgsql-performance@postgresql.org
Subject: Re: Question about memory allocations
Date: Fri, 13 Apr 2007 20:35:55 +1200
Message-ID: <1176453355.609.4.camel@hippy.mcmillan.net.nz> (raw)
In-Reply-To: <Pine.GSO.4.64.0704101458290.17955@kittyhawk.tanabi.org>
References: <233A9987-ABA5-4491-A304-FDA1F8FCD962@gmail.com>
	<14019.1176155022@sss.pgh.pa.us>
	<22512E5C-A60F-43E7-A370-257F7AF956FD@gmail.com>
	<16374.1176171185@sss.pgh.pa.us>
	<D14BB823-DA04-453C-AD70-248B34F1307B@gmail.com>
	<25200.1176213242@sss.pgh.pa.us>
	<FCEF7DE2-913F-4C36-B117-8363EDE39BF3@gmail.com>
	<26925.1176221294@sss.pgh.pa.us>
	<Pine.GSO.4.64.0704101458290.17955@kittyhawk.tanabi.org>

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.
-------------------------------------------------------------------------

Attachments:

  signature.asc (application/pgp-signature, 188B) download

view thread (11+ messages)  latest in thread

Message-ID: <1176453355.609.4.camel@hippy.mcmillan.net.nz>
Permalink:  ../1176453355.609.4.camel@hippy.mcmillan.net.nz/
Also on:    postgresql.org/message-id/1176453355.609.4.camel@hippy.mcmillan.net.nz

 · 

reply
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: andrew@catalyst.net.nz, cheetah@tanabi.org
  Subject: Re: Question about memory allocations
  In-Reply-To: <1176453355.609.4.camel@hippy.mcmillan.net.nz>

* 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