X-Original-To: pgsql-performance@postgresql.org Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by postgresql.org (Postfix) with ESMTP id 4847E475F53 for ; Fri, 7 Mar 2003 09:29:49 -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 h27ETkx6029934; Fri, 7 Mar 2003 09:29:46 -0500 (EST) To: Sean Chittenden Cc: Neil Conway , Christopher Kings-Lynne , PostgreSQL Performance Subject: Re: [COMMITTERS] pgsql-server/ /configure /configure.in rc/incl ... In-reply-to: <20030307060412.GA19138@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> <1046998072.10527.67.camel@tokyo> <20030307060412.GA19138@perrin.int.nxad.com> Comments: In-reply-to Sean Chittenden message dated "Thu, 06 Mar 2003 22:04:12 -0800" Date: Fri, 07 Mar 2003 09:29:46 -0500 Message-ID: <29933.1047047386@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200303/58 X-Sequence-Number: 1356 Sean Chittenden writes: > Absolutely! Is this a simple benchmark? Yup. Do I think it > simulates PostgreSQL? Eh, not particularly. This would be on what OS? What hardware? What size test file? Do the "iterations" mean so many reads of the entire file, or so many buffer-sized read requests? Did the mmap case actually *read* anything, or just map and unmap the file? Also, what did you do to normalize for the effects of the test file being already in kernel disk cache after the first test? regards, tom lane