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 this by hand so...

Drew

"Andrew Hammond" <andrew.george.hammond@gmail.com> 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 PostgreSQL versions;
(2) if EXEC_BACKEND is defined;
(3) other defines like BLCKSZ, NUM_SLRU_BUFFERS, etc.

So a better way IMHO is not to use perl script -- you have to reinvent the
shmem estimation logic. You can put the logic in a separate function in
backend and export it.

Regards,
Qingqing

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 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 this by hand so...
>
> Drew
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>


---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

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 this by hand so...

I would really welcome your help with the Configurator project, which is
intended to do this (among other things).

--
Josh Berkus
PostgreSQL @ Sun
San Francisco

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend