Skip site navigation (1) Skip section navigation (2)

Re: hanging for 30sec when checkpointing

From: Greg Mennie <gjm(at)caledoncard(dot)com>
To: Steve Crawford <scrawford(at)pinpointresearch(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: hanging for 30sec when checkpointing
Date: 2004-02-16 13:29:03
Message-ID: Pine.LNX.4.44.0402160816060.2036-100000@fargo.caledoncard.com (view raw or flat)
Thread:
Lists: pgsql-admin
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


In response to

pgsql-admin by date

Next:From: Rigmor UkuheDate: 2004-02-16 13:54:00
Subject: Re: Upgrading 7.2.4 to 7.4.1
Previous:From: Jarmo JärvenpääDate: 2004-02-16 12:59:26
Subject: Upgrading 7.2.4 to 7.4.1

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group