Обсуждение: Re: postgresql.conf basic analysis tool

Поиск
Список
Период
Сортировка

Re: postgresql.conf basic analysis tool

От
"Qingqing Zhou"
Дата:
"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