Which SCHED_ for DB server

[Kris Kennaway]

On Thu, Sep 01, 2005 at 10:53:39AM +0200, Claus Guttesen wrote:
> > I'm building a server that will run PostgreSQL with a database
> > containing several 10s of million records. The only things happening on
> > this box will be the SQL processes and other processes to parse raw data
> > and load into the DB. Users = a few connections via HTTP from an
> > intranet server (not more than 5 concurrently).
> > 
> > I was wondering what is the best SCHED_ to set in the kernel.
> > I currently have SCHED_4BSD but was wondering if _ULE would be better
> > for this
> 
> For prod. use I would recommend SCHED_4BSD atm. The 4BSD-scheduler
> does seem to be more stable on SMP and up.

ULE might be OK on SMP with 6.0 and above, but performance seems to be
a bit lower than 4BSD in my tests.  Try it yourself and see which is
better.

Kris
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 187 bytes
Desc: not available
Url : http://lists.freebsd.org/pipermail/freebsd-amd64/attachments/20050905/0adb1b6f/attachment.bin