Re: apparent wraparound

Florian G. Pflug wrote:
> Gregory S. Williamson wrote:
>> You need to edit the postgresql.conf file and increase the
>> max_fsm_pages and
> > max_fsm_relations parameters and then restart postgres (I think you
> > have to actually stop and restart, as opposed to a reload, but I
> could be
> > wrong). You may end up needing to adjust the total amount of RAM
> > allocated to Shared Memory to allow for as large an FSM as you'll
> > need. That requires a system reboot.
> Actually, it doesn't require a system reboot. On debian/ubunut, and
> AFAIK on redhat too, you just need to edit /etc/sysctl.conf, and
> then call sysctl -p to update the in-kernel settings.

Most modern day unix does not need to reboot...

FreeBSD (although there are a couple it still needs to reboot for IIRC)
Linux
MacOSX

None of these need to reboot to set those parameters.

Sincerely,

Joshua D. Drake

>
> greetings, Florian Pflug
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
>

--

=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/