Which SCHED_ for DB server
ohartman at mail.uni-mainz.de
Tue Sep 6 00:46:20 PDT 2005
Kris Kennaway wrote:
>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 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
An, by the way, what are the benefits of ULE at this moment? Is it still
a more experimental scheduler for the far future on SMP based machines
or do we have benefits in UP/SMP?
More information about the freebsd-amd64