Received: from oxmail.ox.ac.uk (oxmail1.ox.ac.uk [129.67.1.1]) by hub.org (8.9.3/8.9.3) with ESMTP id EAA15286 for ; Tue, 24 Aug 1999 04:09:26 -0400 (EDT) (envelope-from moray.mcconnachie@computing-services.oxford.ac.uk) Received: from heraldgate1.oucs.ox.ac.uk ([163.1.2.49] helo=frontend1.herald.ox.ac.uk ident=exim) by oxmail.ox.ac.uk with esmtp (Exim 2.10 #1) id 11JBe1-0001uL-00 for pgsql-sql@postgresql.org; Tue, 24 Aug 1999 09:09:25 +0100 Received: from moraypc.oucs.ox.ac.uk ([163.1.14.118]) by frontend1.herald.ox.ac.uk with esmtp (Exim 2.02 #1) id 11JBe1-0001D8-00 for pgsql-sql@postgreSQL.org; Tue, 24 Aug 1999 09:09:25 +0100 From: Moray McConnachie Date: Tue, 24 Aug 1999 09:06:11 +0100 To: pgsql-sql@postgresql.org Subject: Re: [SQL] 2 million+ entries In-Reply-To: <99082400304208.28253@kashmir> References: <99082400304208.28253@kashmir> Message-ID: Priority: NORMAL X-Mailer: Execmail for Win32 Version 5.0.1 Build (55) MIME-Version: 1.0 Content-Type: Text/Plain; charset="us-ascii" > On Mon, 23 Aug 1999, Michael Richards wrote: > > > >I'd suggest using a *BSD, ie FreeBSD, as it's filsystem performance is > >much better than something like ext2. > People that ought to know tell me: "No. I don't think even the *BSD advocates claim that *BSD beats Linux on large boxes (i.e. SMP and plenty of memory). The only places I can think of off-hand where *BSD advocates can argue even the possibility for better performance against Linux are (1) when heavy swapping is going on (which means the box was badly balanced when bought especially if it's a compute server) and (2) certain unusual network uses (due to design differences and historical curiosities). There are some functionality differences between *BSD and Linux but that's a different issue." However, we were talking about 2 GB plus of memory here... ---------------------- Moray.McConnachie@computing-services.oxford.ac.uk