Date: Tue, 10 Apr 2007 00:57:54 -0400 From: Kris Kennaway <kris@obsecurity.org> To: Kevin Way <kevin@insidesystems.net> Cc: freebsd-performance@freebsd.org Subject: Re: Anyone interested in improving postgresql scaling? Message-ID: <20070410045754.GA41769@xor.obsecurity.org> In-Reply-To: <461B0CD0.8090404@insidesystems.net> References: <461B0CD0.8090404@insidesystems.net>
index | next in thread | previous in thread | raw e-mail
[-- Attachment #1 --] On Tue, Apr 10, 2007 at 12:04:32AM -0400, Kevin Way wrote: > Kris Kennaway wrote: > >If so, then your task is the following: > > > >Make SYSV semaphores less dumb about process wakeups. Currently > >whenever the semaphore state changes, all processes sleeping on the > >semaphore are woken, even if we only have released enough resources > >for one waiting process to claim. i.e. there is a thundering herd > >wakeup situation which destroys performance at high loads. Fixing > >this will involve replacing the wakeup() calls with appropriate > >amounts of wakeup_one(). > Could this cause problem cause a situation where an 8-Core system was > 50-75% slower than an otherwise equivalent 2-Core system? > > I have a graph of my sysbench/pgsql results here: > > http://blog.insidesystems.net/files/sysctl-pgsq-amd64-wtf.png > > As the graph shows, the 8-core system is about half the speed of the > 2-core system at 2 simultaneous threads, and it decays down to > approximately 1/4 the speed of the 2-core system as the # of threads hits 5. > > All other (non-pgsql, non-sysv) tests came back approximately as > expected, but I'm left wondering if I did something wrong, or if 8 cpus > are slower than 2, when it comes to Postgres on currently available FreeBSD. I wouldn't expect 6.2 to have good scaling on 8 cpus for this kind of benchmark. Fixing that was what we have been working on for 7.0 (and basically succeeded). The most important fixes are already in 7.0 CVS, but a possible merge to 6.x will only happen after a suitably conservative delay. Kris [-- Attachment #2 --] -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.7 (FreeBSD) iD8DBQFGGxlSWry0BWjoQKURAlzLAJ9Q0F2UTkn64W9LQ8GLkd+ogDySIwCfUS3F ZIagTRCYOWo6F12ypxTh7BY= =ey3P -----END PGP SIGNATURE-----help
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20070410045754.GA41769>