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
copy link · copy postgr.es
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