[prev in list] [next in list] [prev in thread] [next in thread]
List: postgresql-admin
Subject: Re: [ADMIN] hanging for 30sec when checkpointing
From: Greg Mennie <gjm () caledoncard ! com>
Date: 2004-02-16 13:29:03
Message-ID: Pine.LNX.4.44.0402160816060.2036-100000 () fargo ! caledoncard ! com
[Download RAW message or body]
On Thu, 12 Feb 2004, Steve Crawford wrote:
> I spoke with some 3Ware reps at a trade show and they recommended
> adding the following to /etc/sysctl.conf:
> vm.max-readahead = 256
> vm.min-readahead = 128
>
> These settings take effect at boot. To change on a running system:
> echo 256 > /proc/sys/vm/max-readahead
> echo 128 > /proc/sys/vm/min-readahead
>
> This advice was specific to the 3Ware card on Linux.
>
> Cheers,
> Steve
>
Thanks for the information, Steve.
It didn't cure the write storm, but I'm sure I gained some read performance.
Every little bit helps...
- Greg
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic