Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fnwIi-0003VR-M1 for pgsql-hackers@arkaria.postgresql.org; Fri, 10 Aug 2018 01:33:12 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fnwIf-0006H6-Uq for pgsql-hackers@arkaria.postgresql.org; Fri, 10 Aug 2018 01:33:09 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fnwIf-0006Gz-GK for pgsql-hackers@lists.postgresql.org; Fri, 10 Aug 2018 01:33:09 +0000 Received: from mail-qt0-x244.google.com ([2607:f8b0:400d:c0d::244]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1fnwIX-0000zd-Tl for pgsql-hackers@postgresql.org; Fri, 10 Aug 2018 01:33:08 +0000 Received: by mail-qt0-x244.google.com with SMTP id h4-v6so8731669qtj.7 for ; Thu, 09 Aug 2018 18:33:01 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=2ndquadrant-com.20150623.gappssmtp.com; s=20150623; h=from:subject:to:cc:references:message-id:date:user-agent :mime-version:in-reply-to:content-transfer-encoding:content-language; bh=zCzyZ0Vwt9FD4va6/dmXIZhRn15U6SCa1mru8sHnQG0=; b=G3f6mxh8mYxnvlFfaQ1OmA11xYiZBp88HDnQovlD/0ZrXfQxGIxS2sK03ethIBdNjL gwb5dCDQWUTCBD4prn5elXtW/krgwaqDq7RfuElgy3bwDOtIB2sP2m0OdxqOZPrgltFR kAG2qM2MdijsEPW5pHwIrWwf3z7UdGblw7fKEUdm2hM3Xc/nV5GfiFs3yTHHtbmJToYe M+vTpCK58c7/w9xnhUVTBdMure6aPox1sDcSi4YG3I1ye6XHA/XLrNPxcUBuUfONivnq krr03nm+HgZy56bYog7a+OOqcludlkrqKcR2duGqGh4XMPFrv1hj4FxCJC6XQYoNpBZu +zAw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:from:subject:to:cc:references:message-id:date :user-agent:mime-version:in-reply-to:content-transfer-encoding :content-language; bh=zCzyZ0Vwt9FD4va6/dmXIZhRn15U6SCa1mru8sHnQG0=; b=nb3qL5hACoz/ii9SMLC5wv+/4JeuYc4mo8q464ZliUDcMrZNHt/e4fiDyW+8+A/elt OBfCh6tzuMBeUdVKTGLhqTBmAy2qw9Ly/twnArQXEoCH79W7KCkoahekRsSMmraDF+7u UK7Yjds95VEontDVUXjUAZ6jh8mvm1m+UJZNGl+wzRWcOJuRRtHIaudksvEymnbv+GES IsieriKzrzbrauiSDhMqwPU3Y+nd/6KROWpP2jIT2ff1DpMD/jaV6UMCOLix/OJ6AaBa MY7h0q/uJb+0vHSvJMm83bZUGqQITMlT4OGsCoRatZZH40BoZPssLUfqtazae9VkCq4a J4Sg== X-Gm-Message-State: AOUpUlGa/ScMXF7hhmGWnQ5sCYkDoEQkwRZslIVDQ9qbsKjuEBmGccHA igQR1X7hKfaZUuVD8HOXYNsW X-Google-Smtp-Source: AA+uWPxrtwZloI51i5EyLmKVlq1lNqWieWVunjQd9TjLk7EmdbD8YIQJDQ6WnbJR6xSxR8QFJvA1+w== X-Received: by 2002:aed:2a4a:: with SMTP id k10-v6mr4542086qtf.102.1533864780848; Thu, 09 Aug 2018 18:33:00 -0700 (PDT) Received: from [192.168.10.146] ([98.122.175.38]) by smtp.gmail.com with ESMTPSA id z123-v6sm5299619qke.68.2018.08.09.18.32.59 (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Thu, 09 Aug 2018 18:33:00 -0700 (PDT) From: Andrew Dunstan X-Google-Original-From: Andrew Dunstan Subject: Re: PATCH: pgbench - option to build using ppoll() for larger connection counts To: Thomas Munro , "Rady, Doug" Cc: Fabien COELHO , Andres Freund , "pgsql-hackers@postgresql.org" , Robert Haas References: <23D017C9-81B7-484D-8490-FD94DEC4DF59@amazon.com> <16744C85-E44E-4354-9E3D-45A7C9BDB19B@amazon.com> <81936381-841A-459D-9FE5-18659680355C@amazon.com> <654A1247-8E1E-4E9C-937D-9119B1731FF2@amazon.com> <20180301083404.z2sbnjdaw7gxvz6x@alap3.anarazel.de> <20180304001409.tajjmefj7yq6xs77@alap3.anarazel.de> <2879AF01-915B-4D07-9F42-04F7CA71908D@amazon.com> <22D7FB26-058A-4022-A94C-FFDAD9F97764@amazon.com> <98fd9aa2-f5f0-d872-902f-c217cae1eed3@2ndQuadrant.com> Message-ID: <0ec3b23a-5ade-09f9-8ddc-78ebbfcbc6cf@2ndQuadrant.com> Date: Thu, 9 Aug 2018 21:32:58 -0400 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101 Thunderbird/52.4.0 MIME-Version: 1.0 In-Reply-To: <98fd9aa2-f5f0-d872-902f-c217cae1eed3@2ndQuadrant.com> Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 8bit Content-Language: en-MW List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 08/09/2018 05:46 PM, Andrew Dunstan wrote: > > > On 08/09/2018 12:45 PM, Andrew Dunstan wrote: >> >> >> On 07/03/2018 07:52 PM, Andrew Dunstan wrote: >>> >>> >>> On 05/17/2018 01:23 AM, Thomas Munro wrote: >>>> On Tue, Mar 27, 2018 at 9:23 AM, Rady, Doug >>>> wrote: >>>>> pgbench11-ppoll-v12.patch >>>> Hi Doug, >>>> >>>> FYI this patch is trying and failing to use ppoll() on Windows: >>>> >>>> https://ci.appveyor.com/project/postgresql-cfbot/postgresql/build/1.0.30 >>>> >>>> >>> >>> >>> It's still failing -  see >>> >>> >>> I'm setting this back to "Waiting on Author" until that's fixed. >>> >> >> >> The author hasn't replied, but the attached seems to have cured the >> bitrot so that it at least applies. Let's see what the cfbot makes of >> it and then possibly fix any Windows issues. >> >> >> > > > And there's still a Windows problem which I think is cured in the > attached patch > and the CFBot agrees. cheers andrew -- Andrew Dunstan https://www.2ndQuadrant.com PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services