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
pgsql-hackers by date
|Next:||From: Greg Smith||Date: 2008-12-01 07:40:39|
|Subject: Re: Simple postgresql.conf wizard|
|Previous:||From: Rushabh Lathia||Date: 2008-12-01 05:21:40|
|Subject: Re: Server Crash into contrib module ISN into 64bit OS|