Re: Problem with database performance, Debian 4gb ram ?

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Massan <grant(dot)massan(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Problem with database performance, Debian 4gb ram ?
Date: 2009-11-06 15:39:27
Message-ID: 20091106153927.GE3840@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Aris Samad-Yahaya 2009-11-08 03:15:40 CREATE TABLE slowing down significantly over time
Previous Message Kevin Grittner 2009-11-06 15:26:27 Re: Problem with database performance, Debian 4gb ram ?