X-Original-To: pgsql-performance@postgresql.org Received: from bob.samurai.com (bob.samurai.com [205.207.28.75]) by postgresql.org (Postfix) with ESMTP id 22EA447638C for ; Thu, 6 Mar 2003 19:47:54 -0500 (EST) Received: from DU150.N224.ResNet.QueensU.CA (DU150.N224.ResNet.QueensU.CA [130.15.224.150]) by bob.samurai.com (Postfix) with ESMTP id CF93F1F27; Thu, 6 Mar 2003 19:47:56 -0500 (EST) Subject: Re: [COMMITTERS] pgsql-server/ /configure /configure.in rc/incl ... From: Neil Conway To: Sean Chittenden Cc: Tom Lane , Christopher Kings-Lynne , PostgreSQL Performance In-Reply-To: <20030307003640.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> <15071.1046964336@sss.pgh.pa.us> <20030307003640.GF79234@perrin.int.nxad.com> Content-Type: text/plain Organization: Message-Id: <1046998072.10527.67.camel@tokyo> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.2.2 Date: 06 Mar 2003 19:47:52 -0500 Content-Transfer-Encoding: 7bit X-Archive-Number: 200303/53 X-Sequence-Number: 1351 On Thu, 2003-03-06 at 19:36, Sean Chittenden wrote: > I don't have my copy of Steven's handy (it's some 700mi away atm > otherwise I'd cite it), but if Tom or someone else has it handy, look > up the example re: the performance gain from read()'ing an mmap()'ed > file versus a non-mmap()'ed file. The difference is non-trivial and > _WELL_ worth the time given the speed increase. Can anyone confirm this? If so, one easy step we could take in this direction would be adapting COPY FROM to use mmap(). Cheers, Neil -- Neil Conway || PGP Key ID: DB3C29FC