Re: [GENERAL] Ubutu 12.04 and PostgreSQL9.2.1

2012-12-06 Thread a...@hsk.hk
Hi, thank you very much! On 7 Dec 2012, at 11:47 AM, Ondrej Ivanič wrote: > Hi, > > On 7 December 2012 14:17, a...@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: curren

Re: [GENERAL] Ubutu 12.04 and PostgreSQL9.2.1

2012-12-06 Thread Ondrej Ivanič
Hi, On 7 December 2012 14:17, a...@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

[GENERAL] Ubutu 12.04 and PostgreSQL9.2.1

2012-12-06 Thread a...@hsk.hk
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