Re: Optimize update query
| От | Mark Kirkwood |
|---|---|
| Тема | Re: Optimize update query |
| Дата | |
| Msg-id | 50B6E4FC.8040605@catalyst.net.nz обсуждение |
| Ответ на | Re: Optimize update query (Niels Kristian Schjødt <nielskristian@autouncle.com>) |
| Список | 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 > >
В списке pgsql-performance по дате отправления: