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 <[EMAIL PROTECTED]> http://svana.org/kleptog/ > Please line up in a tree and maintain the heap invariant while > boarding. Thank you for flying nlogn airlines.
signature.asc
Description: Digital signature
