PostgreSQL 9.3 benchmarks

B. Estrade estrabd at gmail.com
Mon Mar 10 05:54:44 PDT 2014


Nice work.

Looks like FreeBSD 10 is not fully utilizing all the cores or there are
some serious migration/contention issues going on. Trying FreeBSD 9.x might
help in pointing to any 10.x (still a young distro) issues.  You may also
want to try some artificial benchmarks that are used specifically for
testing SMP scaling - like the NASA NPBs -
https://www.nas.nasa.gov/publications/npb.html .

Brett


On Mon, Mar 10, 2014 at 4:58 AM, Francois Tigeot <ftigeot at wolfpond.org>wrote:

> On Mon, Mar 10, 2014 at 09:46:25AM +0100, Sascha Wildner wrote:
> >
> > The FreeBSD numbers certainly don't look right (as in, realistic). Are
> you
> > sure there is no configuration issue?
>
> They are 100% reproductible; I installed FreeBSD on both ZFS and UFS2 to be
> sure ZFS didn't play any trick with memory but to no avail.
>
> I didn't use any special configuration apart from the Postgres changes. If
> there's some magical switch to make FreeBSD perform better, I'd like to
> know
> it.
>
> --
> Francois Tigeot
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.dragonflybsd.org/pipermail/users/attachments/20140310/c0e2ecfa/attachment-0013.html>


More information about the Users mailing list