| From: | Thomas Munro <thomas(dot)munro(at)enterprisedb(dot)com> |
|---|---|
| To: | Torsten Zuehlsdorff <mailinglists(at)toco-domains(dot)de> |
| Cc: | Keith Fiske <keith(at)omniti(dot)com>, Matteo Beccati <php(at)beccati(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Andres Freund <andres(at)anarazel(dot)de>, Heikki Linnakangas <hlinnaka(at)iki(dot)fi>, Marko Tiikkaja <marko(at)joh(dot)to>, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org>, Noah Misch <noah(at)leadboat(dot)com> |
| Subject: | Re: [HACKERS] kqueue |
| Date: | 2017-12-05 11:53:22 |
| Message-ID: | CAEepm=2CMdjAqsJ2rT9T42dPERPeHhTUQmbn1Mi2r89zyH3Z4g@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Thu, Jun 22, 2017 at 7:19 PM, Thomas Munro
<thomas(dot)munro(at)enterprisedb(dot)com> wrote:
> I don't plan to resubmit this patch myself, but I was doing some
> spring cleaning and rebasing today and I figured it might be worth
> quietly leaving a working patch here just in case anyone from the
> various BSD communities is interested in taking the idea further.
Since there was a mention of kqueue on -hackers today, here's another
rebase. I got curious just now and ran a very quick test on an AWS 64
vCPU m4.16xlarge instance running image "FreeBSD
11.1-STABLE-amd64-2017-08-08 - ami-00608178". I set shared_buffers =
10GB and ran pgbench approximately the same way Heikki and Keith did
upthread:
pgbench -i -s 200 postgres
pgbench -M prepared -j 6 -c 6 -S postgres -T60 -P1
pgbench -M prepared -j 12 -c 12 -S postgres -T60 -P1
pgbench -M prepared -j 24 -c 24 -S postgres -T60 -P1
pgbench -M prepared -j 36 -c 36 -S postgres -T60 -P1
pgbench -M prepared -j 48 -c 48 -S postgres -T60 -P1
The TPS numbers I got (including connections establishing) were:
clients master patched
6 146,215 147,535 (+0.9%)
12 273,056 280,505 (+2.7%)
24 360,751 369,965 (+2.5%)
36 413,147 420,769 (+1.8%)
48 416,189 444,537 (+6.8%)
The patch appears to be doing something positive on this particular
system and that effect was stable over a few runs.
--
Thomas Munro
http://www.enterprisedb.com
| Attachment | Content-Type | Size |
|---|---|---|
| kqueue-v8.patch | application/octet-stream | 16.5 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Amit Kapila | 2017-12-05 12:24:41 | Re: es_query_dsa is broken |
| Previous Message | Amit Kapila | 2017-12-05 11:02:00 | Re: explain analyze output with parallel workers - question about meaning of information for explain.depesz.com |