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

Re: Stripping kernel FreeBSD - postgres

From: Alban Hertroys <alban(at)magproductions(dot)nl>
To: Enrico <scotty(at)linuxtime(dot)it>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Stripping kernel FreeBSD - postgres
Date: 2006-11-30 14:10:31
Message-ID: 456EE657.6010103@magproductions.nl (view raw or flat)
Thread:
Lists: pgsql-general
Enrico wrote:
>> http://www.freebsd.org/doc/it_IT.ISO8859-15/books/handbook/kernelconfig.html
>>
> 
> Hi Bill
> I already read your link and it is not specific for Postgres, I'm searching for a 
> more specific document.

You'll probably want a lot of shared memory, but you can set that using
sysctls.
If you're on a multi-cpu system, you'll want SMP.
If you're on a hyperthreading machine, you'll have to choose whether you
want that on or off (don't know what's best for PostgreSQL).
If you're on a 32-bit platform with lots of RAM, you may need PAE.
Other than that, I really wouldn't know.

What kind of kernel options do you expect to have any impact on database
performance?

You could build a couple of different kernels with different configs and
see what works best for you. I suppose hyper-threading or not and PAE or
not are the best candidates for experimentation.

I know there're quite a few FreeBSD users among the people here and I've
always kinda disliked system administration, so I suspect I'm not the
best candidate for answering your question :P
-- 
Alban Hertroys
alban(at)magproductions(dot)nl

magproductions b.v.

T: ++31(0)534346874
F: ++31(0)534346876
M:
I: www.magproductions.nl
A: Postbus 416
   7500 AK Enschede

// Integrate Your World //

In response to

pgsql-general by date

Next:From: Stephen HarrisDate: 2006-11-30 14:11:30
Subject: Re: Shutting down a warm standby database in 8.2beta3
Previous:From: Walter VaughanDate: 2006-11-30 14:09:44
Subject: Re: Stripping kernel FreeBSD - postgres

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