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

help / color / mirror / Atom feed
From: Gregory Stark <stark@enterprisedb.com>
To: Jim Nasby <decibel@decibel.org>
Cc: Greg Smith <gsmith@gregsmith.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Volunteer to build a configuration tool
Date: Tue, 26 Jun 2007 09:01:59 +0100
Message-ID: <87odj3dtzc.fsf@oxford.xeocode.com> (raw)
In-Reply-To: <BA5FEC30-926B-4FC5-BF17-E1BECE1B6BDD@decibel.org>
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>
	<A3AC4FA47DC0B1458C3E5396E685E63302395E74@SAB-DC1.sab.uiuc.edu>
	<Pine.GSO.4.64.0706231522460.1349@westnet.com>
	<BA5FEC30-926B-4FC5-BF17-E1BECE1B6BDD@decibel.org>

"Jim Nasby" <decibel@decibel.org> writes:

> The real issue is that the "stock" postgresql.conf is just horrible. It was
> originally tuned for something like a 486, but even the recent  changes have
> only brought it up to the "pentium era" (case in point:  24MB of shared buffers
> equates to a machine with 128MB of memory,  give or take). 

I think it's more that the stock configure has to assume it's not a dedicated
box. Picture someone installing Postgres on their debian box because it's
required for Gnucash. Even having 24M suddenly disappear from the box is quite
a bit.

-- 
  Gregory Stark
  EnterpriseDB          http://www.enterprisedb.com




view thread (33+ messages)  latest in thread

Message-ID: <87odj3dtzc.fsf@oxford.xeocode.com>
Permalink:  ../87odj3dtzc.fsf@oxford.xeocode.com/
Also on:    postgresql.org/message-id/87odj3dtzc.fsf@oxford.xeocode.com

 · 

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: stark@enterprisedb.com, decibel@decibel.org, gsmith@gregsmith.com
  Subject: Re: Volunteer to build a configuration tool
  In-Reply-To: <87odj3dtzc.fsf@oxford.xeocode.com>

* 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