Re: postgresql.conf basic analysis tool

Поиск
Список
Период
Сортировка
От Qingqing Zhou
Тема Re: postgresql.conf basic analysis tool
Дата
Msg-id e9494m$1rd2$1@news.hub.org
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: Marc Munro
Дата:
Сообщение: Re: pre_load_libraries
Следующее
От: "Jaime Casanova"
Дата:
Сообщение: Re: Updateable views for 8.2 or 8.3?