From owner-freebsd-questions@FreeBSD.ORG  Fri Mar 31 00:34:01 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 2DF4E16A422
	for <freebsd-questions@freebsd.org>;
	Fri, 31 Mar 2006 00:34:01 +0000 (UTC)
	(envelope-from wmoran@collaborativefusion.com)
Received: from mx00.pub.collaborativefusion.com
	(mx00.pub.collaborativefusion.com [206.210.89.199])
	by mx1.FreeBSD.org (Postfix) with ESMTP id B0CFD43D9D
	for <freebsd-questions@freebsd.org>;
	Fri, 31 Mar 2006 00:33:57 +0000 (GMT)
	(envelope-from wmoran@collaborativefusion.com)
Received: from localhost (monrovll-cuda1-24-53-250-148.pittpa.adelphia.net
	[24.53.250.148])
	(AUTH: LOGIN wmoran, TLS: TLSv1/SSLv3,256bits,AES256-SHA)
	by wingspan with esmtp; Thu, 30 Mar 2006 19:33:56 -0500
	id 00056423.442C78F4.0000ABF7
Date: Thu, 30 Mar 2006 19:33:55 -0500
From: Bill Moran <wmoran@collaborativefusion.com>
To: Miguel <mmiranda@123.com.sv>
Message-Id: <20060330193355.66256357.wmoran@collaborativefusion.com>
In-Reply-To: <442C6CAF.7020601@123.com.sv>
References: <442B2FC6.9040001@123.com.sv>
	<20060330011834.GA84658@xor.obsecurity.org>
	<c39ec84c0603300047u5530fc1fjb1ba93fcafcd490d@mail.gmail.com>
	<442BF0BB.8010504@123.com.sv>
	<20060330150136.GA12982@xor.obsecurity.org>
	<c39ec84c0603301151s77b37291x3ac1f79582cd753e@mail.gmail.com>
	<442C3B17.4060308@123.com.sv>
	<c39ec84c0603301258j4b31df83g2ab9481a8fc3761f@mail.gmail.com>
	<442C6CAF.7020601@123.com.sv>
Organization: Collaborative Fusion
X-Mailer: Sylpheed version 1.0.6 (GTK+ 1.2.10; i386-portbld-freebsd5.4)
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
Cc: freebsd-questions@freebsd.org, usleepless@gmail.com
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: Fri, 31 Mar 2006 00:34:01 -0000

Miguel <mmiranda@123.com.sv> wrote:

> usleepless@gmail.com wrote:
> 
> >Miguel
> >
> >>attached is my config file, shared_buffers are 25% of total RAM
> >>im guessing that this is a disk controlled bug or something, when i
> >>execute any query involving many rows, the server response is very low,
> >>ssh, su, even copy or rename a file, cpu usage remains ~87% idle though
> >>    
> >you are not inserting into an indexed table, are you?
> 
> yes, i am...
> is that a problem?

Yes.  BIG problem.

1) Create the tables without indexes
2) Insert data
3) Create the indexes

This will be much, much faster than inserting 3G of data into an indexed
table.

-- 
Bill Moran
Potential Technologies
http://www.potentialtech.com