Re: PostgreSQL performance on FreeBSD

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'.