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

Re: Simple postgresql.conf wizard

From: Martijn van Oosterhout <kleptog(at)svana(dot)org>
To: Greg Smith <gsmith(at)gregsmith(dot)com>
Cc: Josh Berkus <josh(at)agliodbs(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Simple postgresql.conf wizard
Date: 2008-12-01 07:36:52
Message-ID: 20081201073652.GA29028@svana.org (view raw or flat)
Thread:
Lists: pgsql-hackers
On Sun, Nov 30, 2008 at 09:17:37PM -0500, Greg Smith wrote:
> That's what I ended up doing.  The attached version of this script and its 
> data files (I dumped all the useful bits in the current HEAD pg_settings 
> for it to use) now hits all of the initial goals I had for a useful 
> working tool here.  Here's a sample run on a system with 8GB of RAM and 
> the default "mixed" workload.  I told the tool absolutely nothing:
> 
> ./pgtune -i ~/data/postgresql.conf

Looks very nice.

> shared_buffers = 1920MB # pg_generate_conf wizard 2008-11-30

Do you have a check somewhere to see if this exceeds the total SYSV
memory allowed by the OS. Otherwise you've just output an unstartable
config. The output of /sbin/sysctl should tell you.

Have a nice day,
-- 
Martijn van Oosterhout   <kleptog(at)svana(dot)org>   http://svana.org/kleptog/
> Please line up in a tree and maintain the heap invariant while 
> boarding. Thank you for flying nlogn airlines.

In response to

Responses

pgsql-hackers by date

Next:From: Greg SmithDate: 2008-12-01 07:40:39
Subject: Re: Simple postgresql.conf wizard
Previous:From: Rushabh LathiaDate: 2008-12-01 05:21:40
Subject: Re: Server Crash into contrib module ISN into 64bit OS

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