From: Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
To: Niels Kristian Schjødt <nielskristian@autouncle.com>
Cc: sthomas@optionshouse.com, Willem Leenen <willem_leenen@hotmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Optimize update query
Date: Thu, 29 Nov 2012 17:30:52 +1300
Message-ID: <50B6E4FC.8040605@catalyst.net.nz> (raw)
In-Reply-To: <F9939192-448B-41FF-9FB1-61343754D050@autouncle.com>
References: <1C199C0D-13DF-47B3-944A-B0560C6D2E5A@autouncle.com>
<50B61ABF.4070000@optionshouse.com>
<50B6223B.6000100@mejor.pl>
<DUB104-W48E83E17609D570C42B5AD8F5D0@phx.gbl>
<CAC9DA03-64C2-45E2-9B88-703F9768F574@autouncle.com>
<50B641AD.3020204@optionshouse.com>
<F9939192-448B-41FF-9FB1-61343754D050@autouncle.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
In later kernels these have been renamed:
Welcome to Ubuntu 12.04.1 LTS (GNU/Linux 3.2.0-32-generic x86_64)
$ sysctl -a|grep dirty
vm.dirty_background_ratio = 5
vm.dirty_background_bytes = 0
vm.dirty_ratio = 10
vm.dirty_bytes = 0
vm.dirty_writeback_centisecs = 500
vm.dirty_expire_centisecs = 3000
You the option of specifying either a ratio, or - more usefully for
machines with a lot of ram - bytes.
Regards
Mark
P.s: People on this list usually prefer it if you *bottom* post (i.e
reply underneath the original).
On 29/11/12 16:32, Niels Kristian Schjødt wrote:
> Hi, I have started to implement your suggestions . I have a small error so far though. The "vm.dirty_writeback_ratio = 1" command rerurns:
> error: "vm.dirty_writeback_ratio" is an unknown key
> I'm on ubuntu 12.04
>
>
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: mark.kirkwood@catalyst.net.nz, nielskristian@autouncle.com, willem_leenen@hotmail.com
Subject: Re: Optimize update query
In-Reply-To: <50B6E4FC.8040605@catalyst.net.nz>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox