pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Fabien COELHO <coelho@cri.ensmp.fr>
Cc: Andres Freund <andres@anarazel.de>
Cc: PostgreSQL Bugs <pgsql-bugs@lists.postgresql.org>
Cc: David Rowley <dgrowleyml@gmail.com>
Cc: Jawarilal, Manish <Manish.Jawarilal@dell.com>
Subject: Re: pgbench bug / limitation
Date: Sat, 06 Jun 2020 10:57:13 -0400
Message-ID: <1673150.1591455433@sss.pgh.pa.us> (raw)
In-Reply-To: <alpine.DEB.2.22.394.2006060851480.32228@pseudo>
References: <BL0PR1901MB198583EAC6C8A3B770D20F1AED8A0@BL0PR1901MB1985.namprd19.prod.outlook.com>
	<384920.1591027137@sss.pgh.pa.us>
	<CAApHDvrjWtJa9oQ98oH+9PCvTgOkGZP+gcmottNX95sjn6o9fQ@mail.gmail.com>
	<512846.1591057287@sss.pgh.pa.us>
	<CAApHDvpMEAaZMxtzixbnb7ySo=Kb1eUfshEB-y4YOm8SgGrpiw@mail.gmail.com>
	<alpine.DEB.2.22.394.2006021258170.87735@pseudo>
	<CAApHDvpDBkjj6a+Ld-9YGW=_Bcxss8Yyz_QYjtjus3WUsTb+1g@mail.gmail.com>
	<1507639.1591375547@sss.pgh.pa.us>
	<D973F4AF-8949-42C1-ABF1-E87F7C63E746@anarazel.de>
	<1509305.1591378355@sss.pgh.pa.us>
	<20200605174418.zbb4egfe5wxhv2yd@alap3.anarazel.de>
	<1510961.1591380652@sss.pgh.pa.us>
	<alpine.DEB.2.22.394.2006060851480.32228@pseudo>

Fabien COELHO <coelho@cri.ensmp.fr> writes:
>> Agreed.  Seems like the best answer is to get in bed with the Windows
>> representation of fd_set, since we cannot avoid knowing that it is
>> different from other platforms' versions.  I suggest that we might as
>> well get all the way in and dodge the FD_SETSIZE limitation altogether,
>> as per the attached utterly-untested draft patch.

> ISTM that the patch your propose, a full reimplementation of the abstract 
> poll/select fd set interface for windows, is overkill because it adds 
> about 80 lines of code. ISTM that just redefining some macros is enough to 
> get the same performance benefit without adding much to the code base, but 
> maybe I'm missing something. At least, I do not think that getting rid of 
> the FD_SETSIZE redefinition for windows is worth all that trouble.

I think it's worth doing because it puts the Windows implementation at
full feature parity with Unixen, ie, there's no hard-wired limit on the
number of connections.  I'm also not that thrilled with trying to make
one code path work with two fundamentally different implementations.
We've found out that just because Microsoft claims their implementation
is compatible with POSIX doesn't make it so, and I'd rather not have
warts in our source code from trying to paper over that.

Lastly, I think it's entirely likely that someone will come up with a
Windows-native implementation at some point, so that we'd have the extra
code lines anyway.

			regards, tom lane





view thread (26+ messages)  latest in thread

Message-ID: <1673150.1591455433@sss.pgh.pa.us>
Permalink:  ../1673150.1591455433@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/1673150.1591455433@sss.pgh.pa.us

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-bugs@postgresql.org
  Cc: tgl@sss.pgh.pa.us, coelho@cri.ensmp.fr, andres@anarazel.de, pgsql-bugs@lists.postgresql.org, dgrowleyml@gmail.com, Manish.Jawarilal@dell.com
  Subject: Re: pgbench bug / limitation
  In-Reply-To: <1673150.1591455433@sss.pgh.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox