Postgres Pro
Downloads
Home   >   mailing lists

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

From ac@hsk.hk
Subject Ubutu 12.04 and PostgreSQL9.2.1
Date
Msg-id 1AF2BB65-B0DF-42B0-91E6-00AE10E361B5@hsk.hk
Whole thread Raw
In response to Re: Statistics mismatch between n_live_tup and actual row count  (tim_wilson <tim.wilson@telogis.com>)
Responses Re: Ubutu 12.04 and PostgreSQL9.2.1  (Ondrej Ivanič <ondrej.ivanic@gmail.com>)
List pgsql-general
Tree view 
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
PostgreSQLdatabase performance?  

Thanks
ac

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Statistics mismatch between n_live_tup and actual row count
Next
From: Tom Lane
Date:
Subject: Re: Statistics mismatch between n_live_tup and actual row count