Re: Kernel Resources and max_connections - Mailing list pgsql-performance

From Jim C. Nasby
Subject Re: Kernel Resources and max_connections
Date
Msg-id 20050504040718.GU47820@decibel.org
Whole thread Raw
In response to Re: Kernel Resources and max_connections  (Mark Kirkwood <markir@paradise.net.nz>)
List pgsql-performance
On Wed, May 04, 2005 at 01:46:34PM +1200, Mark Kirkwood wrote:
> (This not-very-clear distinction between what is sysctl'abe and what is
> a kernel tunable is a bit of a downer).

I think this is documented somewhere, though I can't think of where
right now.

Also, note that some sysctl's can only be set in /boot/loader.conf.
hw.ata.wc=0 is an example (which you want to set on any box with IDE
drives if you want fsync to actually do what it thinks it's doing).
--
Jim C. Nasby, Database Consultant               decibel@decibel.org
Give your computer some brain candy! www.distributed.net Team #1828

Windows: "Where do you want to go today?"
Linux: "Where do you want to go tomorrow?"
FreeBSD: "Are you guys coming, or what?"

pgsql-performance by date:

Previous
From: Mischa Sandberg
Date:
Subject: Re: [HACKERS] Bad n_distinct estimation; hacks suggested?
Next
From: Mark Kirkwood
Date:
Subject: Re: Kernel Resources and max_connections