Re: postgres bogged down beyond tolerance

Поиск
Список
Период
Сортировка
От Gregory Stark
Тема Re: postgres bogged down beyond tolerance
Дата
Msg-id 87wssjx388.fsf@oxford.xeocode.com
обсуждение исходный текст
Ответ на postgres bogged down beyond tolerance  ("Tena Sakai" <tsakai@gallo.ucsf.edu>)
Список pgsql-sql
"Tena Sakai" <tsakai@gallo.ucsf.edu> writes:

> Namely, I shutdown the database, issued two commands:
>   /sbin/sysctl -w kernel.shmmax=134217728
>   /sbin/sysctl -w kernel.shmall=2097152
> and rebooted the computer.
>
> After it came up, I checked the shmmax and it is set
> as 33554432.  Which surprised me.  Since I used -w
> flag, I thought it should've written to /etc/sysctl.conf,
> but there is no such entry at all and the data of this
> file is from 2006.


sysctl changes the values for the running kernel. /etc/sysctl is a file you
edit manually to tell the boot scripts what values to store (using sysctl) so
you don't have to run sysctl every time you reboot.


--  Gregory Stark EnterpriseDB          http://www.enterprisedb.com Ask me about EnterpriseDB's PostGIS support!


В списке pgsql-sql по дате отправления:

Предыдущее
От: Jean-David Beyer
Дата:
Сообщение: Re: Is there anything special about pg_dump's compression?
Следующее
От: "Sabin Coanda"
Дата:
Сообщение: EXPLAIN ANALYZE inside functions