shared_buffers and Shared Memory Segments

From: "Anjan Dave" <adave(at)vantage(dot)com>
To: <pgsql-performance(at)postgresql(dot)org>
Subject: shared_buffers and Shared Memory Segments
Date: 2004-11-01 17:37:53
Message-ID: 4BAFBB6B9CC46F41B2AD7D9F4BBAF78501B27800@vt-pe2550-001.vantage.vantage.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hello,

I am trying to understand the output of the 'ipcs' command during peak
activity and how I can use it to possibly tune the shared_buffers...

Here's what I see right now: (ipcs -m) - (Host is RHAS 3.0)

------ Shared Memory Segments --------

key shmid owner perms bytes nattch status

0x0052e2c1 1966080 postgres 600 92078080 322

What is nattch? Is this the num of segments attached? Is it saying that
about 92MB is used out of 512MB?

-Shared memory segment size is defined to be 512MB

-Currently, shared_buffers are at 80MB (10240)

Here's the 'top' output:

12:29:42 up 24 days, 15:04, 6 users, load average: 2.28, 1.07, 1.07

421 processes: 414 sleeping, 3 running, 4 zombie, 0 stopped

CPU states: cpu user nice system irq softirq iowait idle

total 83.6% 0.0% 40.8% 0.0% 7.6% 76.4% 190.0%

cpu00 20.9% 0.0% 9.0% 0.3% 0.1% 22.5% 46.8%

cpu01 19.2% 0.0% 10.6% 0.0% 7.3% 14.4% 48.3%

cpu02 15.0% 0.0% 7.3% 0.0% 0.0% 8.6% 68.9%

cpu03 28.6% 0.0% 14.0% 0.0% 0.1% 31.0% 26.0%

Mem: 7973712k av, 7675856k used, 297856k free, 0k shrd, 149220k
buff

3865444k actv, 2638404k in_d, 160092k in_c

Swap: 4096532k av, 28k used, 4096504k free 6387092k
cached

Can I conclude anything from these outputs and the buffer setting?

Appreciate any thoughts.

Thanks,
Anjan

Browse pgsql-performance by date

  From Date Subject
Next Message Josh Berkus 2004-11-01 18:49:06 Re: psql large RSS (1.6GB)
Previous Message Tom Lane 2004-11-01 16:03:07 Re: psql large RSS (1.6GB)