Re: How to increase shared mem for PostgreSQL on FreeBSD

On Thu, 13 Dec 2001, GB Clark II wrote:

> On Thursday 13 December 2001 10:42, Joe Koenig wrote:

[Snip]

> > shared_buffers = 15200
> > sort_mem = 32168
>
> That sort mem is REAL high.  Have you read Bruce's tuning pages?

They're not _that_ off-the-wall:

morannon:~/pgdata>egrep 'sort_mem|shared_buffers' postgresql.conf
sort_mem = 32168
shared_buffers = 15200

morannon:~/pgdata>ipcs

------ Shared Memory Segments --------
key       shmid     owner     perms     bytes     nattch    status
0x0052e2c1 163843    sauron    600       128688128 9

(My postgresql install runs as "sauron" - not "postgres", btw)

morannon:~/pgdata>cat /proc/sys/kernel/shmmax
134217728
morannon:~/pgdata>uname -a
Linux morannon 2.4.13 #2 Mon Oct 29 23:52:00 CST 2001 i686 unknown


--
Dominic J. Eidson
                                        "Baruk Khazad! Khazad ai-menu!" - Gimli
-------------------------------------------------------------------------------
http://www.the-infinite.org/              http://www.the-infinite.org/~dominic/