Re: Kernel Resources and max_connections

From: "Jim C(dot) Nasby" <decibel(at)decibel(dot)org>
To: Mark Kirkwood <markir(at)paradise(dot)net(dot)nz>
Cc: Chris Hebrard <tech2(at)wildcash(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Kernel Resources and max_connections
Date: 2005-05-04 04:07:18
Message-ID: 20050504040718.GU47820@decibel.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)decibel(dot)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?"

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Mark Kirkwood 2005-05-04 05:16:36 Re: Kernel Resources and max_connections
Previous Message Mischa Sandberg 2005-05-04 02:52:16 Re: [PERFORM] Bad n_distinct estimation; hacks suggested?