Re: How to install latest stable postgresql on Debian

From: "Andrus" <kobruleht2(at)hot(dot)ee>
To: "Adrian Klaver" <adrian(dot)klaver(at)gmail(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: How to install latest stable postgresql on Debian
Date: 2011-11-19 20:13:34
Message-ID: 919EA00BFB574D2287E62FBC58B9E4AB@dell2
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>From here(look familiar):
>http://wiki.postgresql.org/wiki/Performance_Optimization
>http://linuxfinances.info/info/quickstart.html
>http://www.westnet.com/~gsmith/content/postgresql/pg-5minute.htm

Thank you.
I tried

# sysctl -w kernel.shmmax=419430400
kernel.shmmax = 419430400
# sysctl -n kernel.shmmax
419430400

according to
http://www.postgresql.org/docs/current/static/kernel-resources.html
this value should be written to /etc/sysctl.conf

I opened /etc/sysctl.conf but it does not contain this value.

How to make this setting persistent ?

Andrus.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tomas Vondra 2011-11-19 20:25:07 Re: Huge number of INSERTs
Previous Message Gavin Flower 2011-11-19 19:53:00 Re: Is it ever necessary to vacuum a table that only gets inserts/updates?