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/
