Re: [HACKERS] postgresql.conf basic analysis tool

2006-07-15 Thread Josh Berkus
Drew, > Is there any interest in a basic perl script that would read through a > postgresql.conf file and calculate approximate memory (and shared > memory) usage? Also, are there any other (simple for now) things I > should look at in the process? Asking because I'm getting annoyed with > doing t

Re: [HACKERS] postgresql.conf basic analysis tool

2006-07-13 Thread Dave Cramer
Andrew, Josh did something like this and I wrote some java to do some of it. It's in a project called pgconfigurator (I think) dave On 12-Jul-06, at 2:46 PM, Andrew Hammond wrote: Is there any interest in a basic perl script that would read through a postgresql.conf file and calculate appro

Re: [HACKERS] postgresql.conf basic analysis tool

2006-07-12 Thread Qingqing Zhou
"Andrew Hammond" <[EMAIL PROTECTED]> wrote > Also, are there any other (simple for now) things I > should look at in the process? > The shared memory estimiation logic is in ipc/ipci.c/CreateSharedMemoryAndSemaphores(). If you want to get an accurate number, you need to consider: (1) different Po