Re: Ubutu 12.04 and PostgreSQL9.2.1 - Mailing list pgsql-general

From ac@hsk.hk
Subject Re: Ubutu 12.04 and PostgreSQL9.2.1
Date
Msg-id 8B822A3B-DB60-4E49-AF75-C2CA223C9DE4@hsk.hk
Whole thread Raw
In response to Re: Ubutu 12.04 and PostgreSQL9.2.1  (Ondrej Ivanič <ondrej.ivanic@gmail.com>)
List pgsql-general
Hi, thank you very much!

On 7 Dec 2012, at 11:47 AM, Ondrej Ivanič wrote:

> Hi,
>
> On 7 December 2012 14:17, ac@hsk.hk <ac@hsk.hk> wrote:
>> I have questions about Linux Write cache sizing:
>>
>> 1) /proc/sys/vm/dirty_ratio : current value (default)  20
>> 2) /proc/sys/vm/dirty_background_ratio: current value (default)  10
>>
>> I am using Ubuntu 12.04 (8GB RAM) and PostgreSQL 9.2.1, what values of these kernel ratios
>> should be set for better PostgreSQL database performance?
>
> Read this thread:
> http://archives.postgresql.org/pgsql-performance/2011-10/msg00076.php
> Mainly,
> - http://archives.postgresql.org/pgsql-performance/2011-10/msg00078.php
> - and http://archives.postgresql.org/pgsql-performance/2011-10/msg00080.php
>
> To sum up:
> - with 8G RAM you should be fine with the defaults
> - keep keep dirty_ratio lower than the size of your disk controller cache
> - you can use dirty_bytes and dirty_background_bytes in recent kernels
>
> --
> Ondrej Ivanic
> (http://www.linkedin.com/in/ondrejivanic)



pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Statistics mismatch between n_live_tup and actual row count
Next
From: Albe Laurenz
Date:
Subject: Re: Setting default privs for a user doesn't seem to work.