Date: Thu, 01 Sep 2005 16:54:52 +1000 From: Norberto Meijome <freebsd@meijome.net> To: freebsd-amd64@freebsd.org Subject: Which SCHED_ for DB server Message-ID: <4316A5BC.1000405@meijome.net>
next in thread | raw e-mail | index | archive | help
hi all, 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 #options SCHED_ULE # ULE scheduler options SCHED_4BSD # 4BSD scheduler # uname -a FreeBSD cerberus.xxx 6.0-BETA3 FreeBSD 6.0-BETA3 #2: Wed Aug 31 11:26:10 EST 2005 root@cerberus.xxxx:/usr/obj/usr/src/sys/CERBERUS amd64 # dmesg | grep -i cpu CPU: AMD Opteron(tm) Processor 250 (2411.12-MHz K8-class CPU) FreeBSD/SMP: Multiprocessor System Detected: 2 CPUs cpu0 (BSP): APIC ID: 0 cpu1 (AP): APIC ID: 1 cpu0: <ACPI CPU> on acpi0 cpu1: <ACPI CPU> on acpi0 SMP: AP CPU #1 Launched! 10 GB swap, raided. 2 GB RAM 4 x SATA 150 drives, 90% of it RAID5 with gvinum. running on a TYAN GT24 http://tyan.com/products/html/gt24b2891_spec.html thanks in advance, Beto
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?4316A5BC.1000405>