| From: | Mark Kirkwood <mark(dot)kirkwood(at)catalyst(dot)net(dot)nz> |
|---|---|
| To: | Niels Kristian Schjødt <nielskristian(at)autouncle(dot)com> |
| Cc: | sthomas(at)optionshouse(dot)com, Willem Leenen <willem_leenen(at)hotmail(dot)com>, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Optimize update query |
| Date: | 2012-11-29 04:30:52 |
| Message-ID: | 50B6E4FC.8040605@catalyst.net.nz |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-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
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Guillaume Cottenceau | 2012-11-29 11:33:50 | 9.2.1 & index-only scans : abnormal heap fetches after VACUUM FULL |
| Previous Message | Claudio Freire | 2012-11-29 03:48:32 | Re: Savepoints in transactions for speed? |