--Sig_/ktPsIHr7PD1VnsaAGF96FL2
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: quoted-printable
Am Thu, 17 Jul 2014 20:15:39 +0430
Hooman Fazaeli <hoomanfazaeli@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'.
>=20
> Thanks for the great work!
>=20
> Did you tested the effect of hyper-threading (on or off) on the results?
>=20
>=20
A "naive" question besides:
Does this labor and effort only affects the work with the PostgreSQL 9.3 da=
tabase and is
recent FreeBSD only optimized for this servicing puprpose or provides this =
also some
benefeits for other high-performance scenarios?
Oliver=20
--Sig_/ktPsIHr7PD1VnsaAGF96FL2
Content-Type: application/pgp-signature; name=signature.asc
Content-Disposition: attachment; filename=signature.asc
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2
iQEcBAEBAgAGBQJTyLaOAAoJEOgBcD7A/5N8MdIIAKTL6TAh/N2rDVC8qx4tIN7V
DiSLcK2cBfkEXgPXJc6krk6QwDE5aTCJh3XUrnp2Fq8YSk+hK1+aVy/4Chr6oe7X
q1wi1UNOvl6FPPntKZI7GFp2ML/1kjwKRMV/JKTfqOXegvlB/jLaEXi0wFkBUnRL
mLnHXf3ORR4asBtleEstFe6YAdwfHwPV5jNs/lZrL9n62I7kf5UyR4e2xHqTrg29
23VNeAkfpqTDpLLAvZmjD4qBev1UtuqqCVwHqbJdPDF/dmXr+tJqWXh8xps4/6++
t1MeVq34uZlOyDZ7l6W/q8UzUx9E+p9wttFLfsksJmZfGFVQ3QQR6ooRXBSLJxE=
=Qr8a
-----END PGP SIGNATURE-----
--Sig_/ktPsIHr7PD1VnsaAGF96FL2--