Re: postgresql.conf basic analysis tool - Mailing list pgsql-hackers

From Qingqing Zhou
Subject Re: postgresql.conf basic analysis tool
Date
Msg-id e9494m$1rd2$1@news.hub.org
Whole thread Raw
List pgsql-hackers
"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




pgsql-hackers by date:

Previous
From: Marc Munro
Date:
Subject: Re: pre_load_libraries
Next
From: "Jaime Casanova"
Date:
Subject: Re: Updateable views for 8.2 or 8.3?