X-Original-To: pgsql-committers@postgresql.org Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by postgresql.org (Postfix) with ESMTP id C22BE47617D for ; Tue, 11 Mar 2003 00:06:19 -0500 (EST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.8/8.12.8) with ESMTP id h2B56Fub002774; Tue, 11 Mar 2003 00:06:15 -0500 (EST) To: Sean Chittenden Cc: Neil Conway , Christopher Kings-Lynne , "Marc G. Fournier" , pgsql-committers@postgresql.org Subject: Re: pgsql-server/ /configure /configure.in rc/incl ... In-reply-to: <20030311045610.GF79234@perrin.int.nxad.com> References: <20030306031656.1876F4762E0@postgresql.org> <032f01c2e390$b1842b20$6500a8c0@fhp.internal> <11077.1046921667@sss.pgh.pa.us> <033f01c2e392$71476570$6500a8c0@fhp.internal> <12228.1046922471@sss.pgh.pa.us> <20030306094117.GA79234@perrin.int.nxad.com> <20030310224706.T35660@hub.org> <20030311041133.GC79234@perrin.int.nxad.com> <018201c2e785$2c12c750$6500a8c0@fhp.internal> <1047357755.357.1.camel@tokyo> <20030311045610.GF79234@perrin.int.nxad.com> Comments: In-reply-to Sean Chittenden message dated "Mon, 10 Mar 2003 20:56:10 -0800" Date: Tue, 11 Mar 2003 00:06:14 -0500 Message-ID: <2773.1047359174@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200303/64 X-Sequence-Number: 9307 Sean Chittenden writes: > That said, what was the performance gain of moving > from select() to poll()? It wasn't the biggest optimization in > PostgreSQL history, nor the smallest, but it was a step forward. -sc That change was not sold as a performance improvement; I doubt that it is one. It was sold as not failing when libpq runs inside an application that has thousands of open files (i.e., more than select() can cope with). "Faster" is debatable, "fails" is not... regards, tom lane