| From: | "Dominic J(dot) Eidson" <sauron(at)the-infinite(dot)org> |
|---|---|
| To: | GB Clark II <postgres(at)vsservices(dot)com> |
| Cc: | Joe Koenig <joe(at)jwebmedia(dot)com>, pgsql General List <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: How to increase shared mem for PostgreSQL on FreeBSD |
| Date: | 2001-12-13 23:17:55 |
| Message-ID: | Pine.LNX.4.33.0112131714490.3309-100000@morannon.the-infinite.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephan Szabo | 2001-12-13 23:18:13 | Re: foreign key creation problem |
| Previous Message | Tom Lane | 2001-12-13 23:06:44 | Re: timestamp('01/12/01') doesn't work in 7.2 beta4 |