Postgres Pro
Downloads
Home   >   mailing lists

Re: Problem with database performance, Debian 4gb ram ? - Mailing list pgsql-performance

From Alvaro Herrera
Subject Re: Problem with database performance, Debian 4gb ram ?
Date
Msg-id 20091106153927.GE3840@alvh.no-ip.org
Whole thread Raw
In response to Problem with database performance, Debian 4gb ram ?  (Massan <grant.massan@gmail.com>)
List pgsql-performance
Tree view 
Massan escribió:

> and I am giving kernels like:
>
> sysctl -w kernel.shmmax=1073741824
> sysctl -w kernel.shmall=2097152
>
> btw, what file I should modify to give this kernels as defaults ?

/etc/sysctl.conf

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

pgsql-performance by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: Problem with database performance, Debian 4gb ram ?
Next
From: "Aris Samad-Yahaya"
Date:
Subject: CREATE TABLE slowing down significantly over time