Re: postgresql.conf basic analysis tool

From: "Qingqing Zhou" <zhouqq(at)cs(dot)toronto(dot)edu>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: postgresql.conf basic analysis tool
Date: 2006-07-13 01:54:15
Message-ID: e9494m$1rd2$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


"Andrew Hammond" <andrew(dot)george(dot)hammond(at)gmail(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Jaime Casanova 2006-07-13 01:58:08 Re: Updateable views for 8.2 or 8.3?
Previous Message ITAGAKI Takahiro 2006-07-13 01:49:33 Resurrecting per-page cleaner for btree