From owner-freebsd-questions@FreeBSD.ORG  Thu Mar 30 08:47:57 2006
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
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 8B6E816A400
	for <freebsd-questions@freebsd.org>;
	Thu, 30 Mar 2006 08:47:57 +0000 (UTC)
	(envelope-from usleepless@gmail.com)
Received: from zproxy.gmail.com (zproxy.gmail.com [64.233.162.204])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 1CE2043D46
	for <freebsd-questions@freebsd.org>;
	Thu, 30 Mar 2006 08:47:57 +0000 (GMT)
	(envelope-from usleepless@gmail.com)
Received: by zproxy.gmail.com with SMTP id l8so401841nzf
	for <freebsd-questions@freebsd.org>;
	Thu, 30 Mar 2006 00:47:56 -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=RPCcrHVM9fTvLydE66nYH9QESph3JiQ2flcwOUfYgQoFJbGrtazf3hIoewPWvY3zMvTWH86FpYoTb+3DMIcREESz0Z+zgNt3MK16h+7OkJGlKSfG6vQGdGmx6WkkCk3Gv51+0EtwH5Jf3j3Cv4N9qVKTziLvJ+sbYj8GA8vzWp4=
Received: by 10.36.250.32 with SMTP id x32mr2239577nzh;
	Thu, 30 Mar 2006 00:47:56 -0800 (PST)
Received: by 10.36.154.7 with HTTP; Thu, 30 Mar 2006 00:47:56 -0800 (PST)
Message-ID: <c39ec84c0603300047u5530fc1fjb1ba93fcafcd490d@mail.gmail.com>
Date: Thu, 30 Mar 2006 10:47:56 +0200
From: usleepless@gmail.com
To: Miguel <mmiranda@123.com.sv>
In-Reply-To: <20060330011834.GA84658@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>
Cc: 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 <freebsd-questions.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-questions>
List-Post: <mailto:freebsd-questions@freebsd.org>
List-Help: <mailto:freebsd-questions-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Thu, 30 Mar 2006 08:47:57 -0000

Miguel,

> On Wed, Mar 29, 2006 at 07:09:26PM -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, an=
d
> > 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:

how do your postgresql.conf's compare? things like shared buffers, fsync...

how big is the file?

regards,

usleep