Re: postgres bogged down beyond tolerance - Mailing list pgsql-sql

From Gregory Stark
Subject Re: postgres bogged down beyond tolerance
Date
Msg-id 87wssjx388.fsf@oxford.xeocode.com
Whole thread Raw
In response to postgres bogged down beyond tolerance  ("Tena Sakai" <tsakai@gallo.ucsf.edu>)
List 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 by date:

Previous
From: Jean-David Beyer
Date:
Subject: Re: Is there anything special about pg_dump's compression?
Next
From: "Sabin Coanda"
Date:
Subject: EXPLAIN ANALYZE inside functions