From owner-freebsd-questions@FreeBSD.ORG Mon Apr 3 13:18:04 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 ED94D16A401 for ; Mon, 3 Apr 2006 13:18:04 +0000 (UTC) (envelope-from usleepless@gmail.com) Received: from zproxy.gmail.com (zproxy.gmail.com [64.233.162.196]) by mx1.FreeBSD.org (Postfix) with ESMTP id 7AD8B43D49 for ; Mon, 3 Apr 2006 13:18:04 +0000 (GMT) (envelope-from usleepless@gmail.com) Received: by zproxy.gmail.com with SMTP id l8so1578688nzf for ; Mon, 03 Apr 2006 06:18:03 -0700 (PDT) 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=G4kk4tL9WAg8IeiPc0AOmVfshwleMmln9zSautACQhuJPb3x7l1KnOpBUa3GjQmvHu+9gdX9kMuNFK8pw5efSnZk4SJMrNF5o/h8vZ7W04vHoacR+p2JYD7j0DSdt/60KQbZ1FF20qeWdFzIEVrTvya7Kfj1dt+zxf9uM/f8gn0= Received: by 10.37.2.75 with SMTP id e75mr4857723nzi; Mon, 03 Apr 2006 06:18:02 -0700 (PDT) Received: by 10.36.153.9 with HTTP; Mon, 3 Apr 2006 06:18:02 -0700 (PDT) Message-ID: Date: Mon, 3 Apr 2006 15:18:02 +0200 From: usleepless@gmail.com To: "Norberto Meijome" In-Reply-To: <20060403225821.45fcc26e@localhost> 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> <20060403225821.45fcc26e@localhost> 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: Mon, 03 Apr 2006 13:18:05 -0000 Beto, i believe he has given up. i would say that on a dedicated database machine 50-75% dedicated(shared) memory is not overkill. wasn't there some other switch which determined wether to page shared-memory out? regards, usleep On 4/3/06, Norberto Meijome wrote: > On Wed, 29 Mar 2006 19:09:26 -0600 > Miguel wrote: > > > Hi, im loading a lot of information to a postgresql 8.1.3 database, > > im using the copy command, using the same file and version of > > postgres in gentoo it spend a few minutes (~4-5), in freebsd > > 6.1-beta4 it has already spent 25 minutes and the server apparently > > is doing nothing, > > [...] > > Hey Miguel, > I would agree with all the comments about memory and buffers - tweak > them till you allocate the right amount (i.e., make sure you don't OVER > allocate...though i'm sure you'd see those errors in the pgsql log. > > what does ktrace show when you attach it to the process that is > importing the data (client and server processes,actually). > > - have you tried doing a binary export and import? I've found them to > be faster, though they may not work for what you need (I think I'm > using them for backups... ). my hardware is pretty much the same as > yours, though 4 GB RAM and 4 drives., but my DB is somewhat larger > > > and the reponse time of remote logins or running > > simple commands like ls -l /etc takes a lot of time (35 secs ort so), > > cpu usage is very low: > > ... and all these commands become responsive as usual the minute you > kill the import process? > > btw, you definitely want to kill the indices / FKs in that table until > you're finished with the initial import - it'll speed things up a lot. > > Beto > _______________________________________________ > freebsd-questions@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-questions > To unsubscribe, send any mail to "freebsd-questions-unsubscribe@freebsd.o= rg" >