Received: from localhost (uranus.hub.org [200.46.204.60]) by postgresql.org (Postfix) with ESMTP id D3CB79FB266 for ; Wed, 8 Nov 2006 13:14:56 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.60]) (amavisd-new, port 10024) with ESMTP id 39773-04 for ; Wed, 8 Nov 2006 13:14:54 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from floppy.pyrenet.fr (news.pyrenet.fr [194.116.145.2]) by postgresql.org (Postfix) with ESMTP id 5F5859FB1BA for ; Wed, 8 Nov 2006 13:14:54 -0400 (AST) Received: by floppy.pyrenet.fr (Postfix, from userid 106) id 3ACF230E1C; Wed, 8 Nov 2006 18:14:52 +0100 (MET) From: Ron Mayer X-Newsgroups: pgsql.performance Subject: Re: Which OS provides the _fastest_ PostgreSQL performance? Date: Wed, 08 Nov 2006 09:14:49 -0800 Organization: Hub.Org Networking Services Lines: 36 Message-ID: <45521089.4090605@cheapcomplexdevices.com> References: <1162845613.083003.34870@e3g2000cwe.googlegroups.com> <454fa7c5$0$625$5a6aecb4@news.aaisp.net.uk> <1162858497.14060.0@proxy02.news.clara.net> <1162863350.101851.181650@k70g2000cwa.googlegroups.com> <1162887032.14110.0@damia.uk.clara.net> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@news.hub.org To: Jean-David Beyer User-Agent: Thunderbird 1.5.0.7 (X11/20060927) In-Reply-To: To: pgsql-performance@postgresql.org X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200611/84 X-Sequence-Number: 21854 Jean-David Beyer wrote: > > Sure, some even read the entire cylinder. But unless the data are stored > contiguously, this does little good. The Linux ext2 and ext3 file systems > try to get more contiguity by allocating (IIRC) 8 blocks each time a write > needs space