Shared memory oddity

From: Steven Lane <stevelcmc(at)mindspring(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Shared memory oddity
Date: 2001-12-10 18:13:49
Message-ID: v03007807b83aa9d92895@[209.242.196.75]
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Why would this happen?

I had a server where postgres appeared to be running very slowly. Following
some advice I found on-line, I boosted the shared memory max for that
machine and told postgres to take 15200 buffers (about 128 meg of shared
memory). For a while this worked great, but today, the system runs very
slowly again.

free and shared memory look like this:

[slane(at)iep slane]$ free
total used free shared buffers cached
Mem: 513940 511652 2288 295248 38100 371896
-/+ buffers/cache: 101656 412284
Swap: 0 0 0
[slane(at)iep slane]$ ipcs

------ Shared Memory Segments --------
key shmid owner perms bytes nattch status

------ Semaphore Arrays --------
key semid owner perms nsems status

------ Message Queues --------
key msqid owner perms used-bytes messages

[slane(at)iep slane]$ cat /proc/sys/kernel.shmmax
cat: /proc/sys/kernel.shmmax: No such file or directory
[slane(at)iep slane]$ cat /proc/sys/kernel/shmmax
160000000

Postgres used to have a big section of shared memory in use. Today, nothing.

postgres 7.1, running on LinuxPPC on a PowerMac G4.

Any ideas?

-- sgl

Browse pgsql-admin by date

  From Date Subject
Next Message Patrick Welche 2001-12-10 19:16:40 Re: duplicate templates, wrong users
Previous Message Boban Acimovic 2001-12-10 18:11:33 Re: [GENERAL] How to get database schema without pg_dump?