Re: PostgreSQL performance on FreeBSD

Am Thu, 17 Jul 2014 20:15:39 +0430
Hooman Fazaeli <hoomanfazaeli_at_gmail.com> schrieb:

> On 7/16/2014 5:59 PM, Konstantin Belousov wrote:
> > On Fri, Jun 27, 2014 at 03:56:13PM +0300, Konstantin Belousov wrote:
> >> Hi,
> >> I did some measurements and hacks to see about the performance and
> >> scalability of PostgreSQL 9.3 on FreeBSD, sponsored by The FreeBSD
> >> Foundation.
> >>
> >> The results are described in https://kib.kiev.ua/kib/pgsql_perf.pdf.
> >> The uncommitted patches, referenced in the article, are available as
> >> https://kib.kiev.ua/kib/pig1.patch.txt
> >> https://kib.kiev.ua/kib/patch-2
> > A followup to the original paper.
> >
> > Most importantly, I identified the cause for the drop on the graph
> > after the 30 clients, which appeared to be the debugging version
> > of malloc(3) in libc.
> >
> > Also there are some updates on the patches.
> >
> > New version of the paper is available at
> > https://www.kib.kiev.ua/kib/pgsql_perf_v2.0.pdf
> > The changes are marked as 'update for version 2.0'.
> 
> Thanks for the great work!
> 
> Did you tested the effect of hyper-threading (on or off) on the results?
> 
> 


A "naive" question besides:

Does this labor and effort only affects the work with the PostgreSQL 9.3 database and is
recent FreeBSD only optimized for this servicing puprpose or provides this also some
benefeits for other high-performance scenarios?

Oliver