Skip site navigation (1) Skip section navigation (2)

Re: Changing the default configuration (was Re:

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Justin Clift <justin(at)postgresql(dot)org>,Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Merlin Moncure <merlin(dot)moncure(at)rcsonline(dot)com>,PostgresSQL Hackers Mailing List <pgsql-hackers(at)postgresql(dot)org>,pgsql-advocacy(at)postgresql(dot)org
Subject: Re: Changing the default configuration (was Re:
Date: 2003-02-11 17:18:48
Message-ID: 200302110918.48614.josh@agliodbs.com (view raw or flat)
Thread:
Lists: pgsql-advocacypgsql-hackerspgsql-performance
Tom, Justin,

> > What I would really like to do is set the default shared_buffers to
> > 1000.  That would be 8 meg worth of shared buffer space.  Coupled with
> > more-realistic settings for FSM size, we'd probably be talking a shared
> > memory request approaching 16 meg.  This is not enough RAM to bother
> > any modern machine from a performance standpoint, but there are probably
> > quite a few platforms out there that would need an increase in their
> > stock SHMMAX kernel setting before they'd take it.

What if we supplied several sample .conf files, and let the user choose which 
to copy into the database directory?   We could have a "high read 
performance" profile, and a "transaction database" profile, and a 
"workstation" profile, and a "low impact" profile.   We could even supply a 
Perl script that would adjust SHMMAX and SHMMALL on platforms where this can 
be done from the command line.

-- 
Josh Berkus
Aglio Database Solutions
San Francisco

In response to

Responses

pgsql-performance by date

Next:From: Rod TaylorDate: 2003-02-11 17:21:13
Subject: Re: Changing the default configuration (was Re:
Previous:From: Tom LaneDate: 2003-02-11 17:18:10
Subject: Re: Changing the default configuration (was Re: [HACKERS] PostgreSQL Benchmarks)

pgsql-hackers by date

Next:From: Rod TaylorDate: 2003-02-11 17:21:13
Subject: Re: Changing the default configuration (was Re:
Previous:From: Tom LaneDate: 2003-02-11 17:18:10
Subject: Re: Changing the default configuration (was Re: [HACKERS] PostgreSQL Benchmarks)

pgsql-advocacy by date

Next:From: Rod TaylorDate: 2003-02-11 17:21:13
Subject: Re: Changing the default configuration (was Re:
Previous:From: Tom LaneDate: 2003-02-11 17:18:10
Subject: Re: Changing the default configuration (was Re: [HACKERS] PostgreSQL Benchmarks)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group