Ubutu 12.04 and PostgreSQL9.2.1

From: "ac(at)hsk(dot)hk" <ac(at)hsk(dot)hk>
To: pgsql-general(at)postgresql(dot)org
Cc: ac(at)hsk(dot)hk
Subject: Ubutu 12.04 and PostgreSQL9.2.1
Date: 2012-12-07 03:17:27
Message-ID: 1AF2BB65-B0DF-42B0-91E6-00AE10E361B5@hsk.hk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

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?

Thanks
ac

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2012-12-07 03:19:22 Re: Statistics mismatch between n_live_tup and actual row count
Previous Message Adrian Klaver 2012-12-07 03:01:43 Re: Statistics mismatch between n_live_tup and actual row count