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

help / color / mirror / Atom feed
From: Dave Page <dpage@postgresql.org>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Greg Smith <gsmith@gregsmith.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Volunteer to build a configuration tool
Date: Thu, 21 Jun 2007 16:09:07 +0100
Message-ID: <467A9493.2090906@postgresql.org> (raw)
In-Reply-To: <16078.1182436152@sss.pgh.pa.us>
References: <A3AC4FA47DC0B1458C3E5396E685E63302395E53@SAB-DC1.sab.uiuc.edu>
	<1182298719.4482.133.camel@ipso.snappymail.ca>
	<Pine.GSO.4.64.0706200040001.7594@westnet.com>
	<7621.1182318230@sss.pgh.pa.us>
	<Pine.GSO.4.64.0706200224430.16657@westnet.com>
	<9001.1182323187@sss.pgh.pa.us>
	<op.tt7mn0m9cigqcu@apollo13>
	<Pine.GSO.4.64.0706201044100.9089@westnet.com>
	<A3AC4FA47DC0B1458C3E5396E685E63302395E6C@SAB-DC1.sab.uiuc.edu>
	<Pine.GSO.4.64.0706210244340.29867@westnet.com>
	<16078.1182436152@sss.pgh.pa.us>

Tom Lane wrote:
> There's another reason for not setting shared_buffers huge, beyond the
> good ones Greg listed: the kernel may or may not consider a large
> shared-memory segment as potentially swappable.  

Another is that on Windows, shared memory access is more expensive and 
various people have noted that the smallest value for shared_buffers you 
can get away with can yield better performance as it leaves more free 
for the kernel to use, more efficiently.

Regards, Dave.




view thread (33+ messages)  latest in thread

Message-ID: <467A9493.2090906@postgresql.org>
Permalink:  ../467A9493.2090906@postgresql.org/
Also on:    postgresql.org/message-id/467A9493.2090906@postgresql.org

 · 

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: dpage@postgresql.org, tgl@sss.pgh.pa.us, gsmith@gregsmith.com
  Subject: Re: Volunteer to build a configuration tool
  In-Reply-To: <467A9493.2090906@postgresql.org>

* 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