Re: was there a change in FreeBSD SHM implementation from

From: Vivek Khera <khera(at)kcilink(dot)com>
To: Vince Vielhaber <vev(at)michvhf(dot)com>
Cc: stable(at)freebsd(dot)org, <pgsql-general(at)postgresql(dot)org>
Subject: Re: was there a change in FreeBSD SHM implementation from
Date: 2002-07-11 15:39:24
Message-ID: 15661.42668.997886.567797@onceler.kciLink.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>>>>> "VV" == Vince Vielhaber <vev(at)michvhf(dot)com> writes:

VV> Have you looked at the FreeBSD section here:

VV> http://www.postgresql.org/idocs/index.php?kernel-resources.html

VV> Most notably, I had to increase SHMMAXPGS on one of my FreeBSD machines.
VV> There doesn't appear to be a sysctl variable for it.

Thanks for the tip. Turns out my SHMALL was less than SHMMAX. Seems
silly that the kernel lets you build it that way, but it does. Upping
SHMALL to be commensurate with SHMMAX fixed my problem. I assume I
did it manually via sysctl before (was nearly a year ago since this
machine was rebooted, so I never noticed it wasn't set in sysctl.conf
or the kernel).

--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D. Khera Communications, Inc.
Internet: khera(at)kciLink(dot)com Rockville, MD +1-240-453-8497
AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Kaare Rasmussen 2002-07-11 15:51:00 Re: I am being interviewed by OReilly
Previous Message Rudi Starcevic 2002-07-11 15:18:24 Re: [SQL] XML to Postgres conversion