From: | Matteo Beccati <php(at)beccati(dot)com> |
---|---|
To: | Thomas Munro <thomas(dot)munro(at)enterprisedb(dot)com> |
Cc: | Andres Freund <andres(at)anarazel(dot)de>, Mateusz Guzik <mjguzik(at)gmail(dot)com>, Keith Fiske <keith(at)omniti(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, 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: | 2018-09-30 08:49:21 |
Message-ID: | b8fa4756-eb52-079a-5f60-a29f6976fb1a@beccati.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hi Thomas,
On 30/09/2018 04:36, Thomas Munro wrote:
> On Sat, Sep 29, 2018 at 7:51 PM Matteo Beccati <php(at)beccati(dot)com> wrote:
>> Out of curiosity, I've installed FreBSD on an identically specced VM,
>> and the select benchmark was ~75k tps for kqueue vs ~90k tps on
>> unpatched master, so maybe there's something wrong I'm doing when
>> benchmarking. Could you please provide proper instructions?
>
> Ouch. What kind of virtualisation is this? Which version of FreeBSD?
> Not sure if it's relevant, but do you happen to see gettimeofday()
> showing up as a syscall, if you truss a backend running pgbench?
I downloaded 11.2 as VHD file in order to run on MS Hyper-V / Win10 Pro.
Yes, I saw plenty of gettimeofday calls when running truss:
> gettimeofday({ 1538297117.071344 },0x0) = 0 (0x0)
> gettimeofday({ 1538297117.071743 },0x0) = 0 (0x0)
> gettimeofday({ 1538297117.072021 },0x0) = 0 (0x0)
> getpid() = 766 (0x2fe)
> __sysctl(0x7fffffffce90,0x4,0x0,0x0,0x801891000,0x2b) = 0 (0x0)
> gettimeofday({ 1538297117.072944 },0x0) = 0 (0x0)
> getpid() = 766 (0x2fe)
> __sysctl(0x7fffffffce90,0x4,0x0,0x0,0x801891000,0x29) = 0 (0x0)
> gettimeofday({ 1538297117.073682 },0x0) = 0 (0x0)
> sendto(9,"2\0\0\0\^DT\0\0\0!\0\^Aabalance"...,71,0,NULL,0) = 71 (0x47)
> recvfrom(9,"B\0\0\0\^\\0P0_1\0\0\0\0\^A\0\0"...,8192,0,NULL,0x0) = 51 (0x33)
> gettimeofday({ 1538297117.074955 },0x0) = 0 (0x0)
> gettimeofday({ 1538297117.075308 },0x0) = 0 (0x0)
> getpid() = 766 (0x2fe)
> __sysctl(0x7fffffffce90,0x4,0x0,0x0,0x801891000,0x29) = 0 (0x0)
> gettimeofday({ 1538297117.076252 },0x0) = 0 (0x0)
> gettimeofday({ 1538297117.076431 },0x0) = 0 (0x0)
> gettimeofday({ 1538297117.076678 },0x0^C) = 0 (0x0)
Cheers
--
Matteo Beccati
Development & Consulting - http://www.beccati.com/
From | Date | Subject | |
---|---|---|---|
Next Message | John Naylor | 2018-09-30 09:32:53 | Sync ECPG scanner with core |
Previous Message | Tomas Vondra | 2018-09-30 08:48:36 | Re: Online enabling of checksums |