Re:PostgreSQL/FreeBSD performance and scalability on a 40-co...
by emaste on Friday June 27, 2014 @09:44PM
(#7957151)
The DragonFly benchmark results included in the reference at the end of this document include DragonFly, FreeBSD 10.0, Centos and Debian. In short, the other operating systems they benchmarked don't display the substantial scalability problem observed on FreeBSD in their test.
Note that there are some concerns with the benchmark technique used here (both the test that's the subject of this post, and the DragonFly testing). Running the pgbench test tool on the same host that's running the database under test can severely impact the results in ways that don't reflect what you'd see in a real deployment. See this post from Attilio Rao for more detail:
http://lists.freebsd.org/pipermail/freebsd-performance/2014-...
The test here was done to push PostgreSQL on FreeBSD to the limit, in order to understand and then eventually fix the bottlenecks; it's not directly useful as an indication of the performance one should expect from a real deployment.
Re:PostgreSQL/FreeBSD performance and scalability on a 40-co...
by gkoz on Saturday June 28, 2014 @05:22AM
(#7957817)
It seems your public domain suffix list needs updating (kiev.ua is a public domain). Someone's posted a link to a relevant Mozilla project recently: https://publicsuffix.org/
* Peak performance came at the number of threads == number of cores (vs hardware threads, being double that).
* How does the same hardware profile when running Linux?
http://lists.dragonflybsd.org/pipermail/users/attachments/20...
Note that there are some concerns with the benchmark technique used here (both the test that's the subject of this post, and the DragonFly testing). Running the pgbench test tool on the same host that's running the database under test can severely impact the results in ways that don't reflect what you'd see in a real deployment. See this post from Attilio Rao for more detail: http://lists.freebsd.org/pipermail/freebsd-performance/2014-...
The test here was done to push PostgreSQL on FreeBSD to the limit, in order to understand and then eventually fix the bottlenecks; it's not directly useful as an indication of the performance one should expect from a real deployment.
https://kib.kiev.ua/kib/pig1.patch.txt
https://kib.kiev.ua/kib/patch-2