From owner-freebsd-questions@FreeBSD.ORG Thu Mar 30 19:51:24 2006 Return-Path: X-Original-To: freebsd-questions@freebsd.org Delivered-To: freebsd-questions@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id C247C16A401 for ; Thu, 30 Mar 2006 19:51:24 +0000 (UTC) (envelope-from usleepless@gmail.com) Received: from zproxy.gmail.com (zproxy.gmail.com [64.233.162.207]) by mx1.FreeBSD.org (Postfix) with ESMTP id 4F48143D45 for ; Thu, 30 Mar 2006 19:51:24 +0000 (GMT) (envelope-from usleepless@gmail.com) Received: by zproxy.gmail.com with SMTP id l8so550809nzf for ; Thu, 30 Mar 2006 11:51:23 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=j+kq0KJeJOpLoHuYibKyNZoT/XauLH6H/qQF2HPYt8V9gL1Fln5NATMkbmsxve99PlnMXLgRCCzee/TayP+M1KPomUmArLRUo4plGe8M5JcBkXApcegIDLU3769xlWrndb3VjRJQLiA2sf/YCHdbZX6NhlukSH939PpQ5nytfaY= Received: by 10.36.250.43 with SMTP id x43mr77942nzh; Thu, 30 Mar 2006 11:51:23 -0800 (PST) Received: by 10.36.154.7 with HTTP; Thu, 30 Mar 2006 11:51:23 -0800 (PST) Message-ID: Date: Thu, 30 Mar 2006 21:51:23 +0200 From: usleepless@gmail.com To: "Kris Kennaway" In-Reply-To: <20060330150136.GA12982@xor.obsecurity.org> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <442B2FC6.9040001@123.com.sv> <20060330011834.GA84658@xor.obsecurity.org> <442BF0BB.8010504@123.com.sv> <20060330150136.GA12982@xor.obsecurity.org> Cc: Miguel , freebsd-questions@freebsd.org Subject: Re: terrible performance in 6.1beta4 X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 30 Mar 2006 19:51:24 -0000 Kris, > > 3.0G > > Well there you go then..you're trying to access a file that is larger > than RAM, so naturally you won't be able to fit it all in RAM, and > with 1GB less RAM in your system you'll spend much more time reading > bits of it from disk and later throwing them away. i know a bit of databases, and assume you do as well, so i am hesative to question your explanation but: the importing of a DB-file ( being tab-sep-copies or SQL dumps ) is a transformation process and does not require all data to be in core ( is that the right terminology? ) at the same moment. it transform x Gigs of input to y Gigs of output. i don't see why the 2GB machine would suffer this hard. unless the 3GB-file is one big table. is it MIguel? then it might be a postgresql hitch. i will have to wait on the .conf files, Miguel has not claimed them to be identical, so i am curious. regards, usleep > > Kris > >